Questions tagged [excel-charts]

In Excel, you can create graphical representations of your data in your spreadsheet in charts.

Charts are visual representations of worksheet data. Charts often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.

Different types of charts serve different purposes.

Pie Charts -- are used to show percentages. For example, a pie chart could be used to show what percentage of your total daily calorie intake is represented by one quadruple cheese and bacon hamburger.

Column Charts -- are used to show comparisons between items of data. Each column in the chart represents the value of one item of data. An example of this would be to compare the calories in a quadruple cheese and bacon hamburger with the calories in a glass of water and a bowl of beet greens.

Bar Charts -- are very similar to column charts, except they run horizontally on the page instead of vertically like column charts.

Line Charts -- are used to show trends over time. Each line in the graph shows the changes in the value of one item of data. For example you could show changes in your weight over a period of months as a result of eating a quadruple cheese and bacon hamburger every day for lunch.

456 questions
0
votes
2 answers

Excel Bar/Column graph showing blank cells

Starting with screenshot: https://i.stack.imgur.com/p1Lzm.png (I'm a new user, can't post images) Working for a call center. We have a program that tracks our time spent in various phone states (so when we're on calls, out to lunch, etc) that can…
Dacromir
  • 186
  • 2
  • 11
0
votes
1 answer

Pie Chart : with text value in columns

want to draw Pie Chart with following data Box | Status --------------------------- Box1 | Scan Box2 | Index Box3 | None Box4 | None Box5 | Process Box6 | Process Box7 | Scan Expected result like this
monikapatelIT
  • 977
  • 14
  • 26
0
votes
1 answer

VBA to update chart based on headers containing some text

I have a chart that helps me plot out a sequence of events by person. I need some classes of events to have consistency when I chart. For example, Jane gets hired twice in her career. I want that class of hire to be the same. However, Excel will…
June
  • 720
  • 10
  • 22
0
votes
2 answers

Excel VBA charts - how to set row and column labels

I'm trying to follow along this tutorial: http://www.homeandlearn.org/vba_charts_sheets.html Here is as far as I've gotten: Sub MakeChart() Dim ChartSheet1 As Chart Set ChartSheet1 = Charts.Add With ChartSheet1 .SetSourceData…
posfan12
  • 2,541
  • 8
  • 35
  • 57
0
votes
0 answers

Excel VBA - Set chart series formula to a dynamic range

I'm trying to use VBA to change the series of several charts to use dynamic ranges instead of static cell ranges. Each time a get a vague 1004 application error. Here's my code: Sub test20() Dim wks As Worksheet, tbl As ListObject Dim…
MJA
  • 350
  • 1
  • 3
  • 15
0
votes
2 answers

Creating a DAX pattern that counts days between a date field and a month value on a chart's x-axis

I am struggling with a DAX pattern to allow me to plot an average duration value on a chart. Here is the problem: My dataset has a field called dtOpened which is a date value describing when something started, and I want to be able to calculate the…
Geoff
  • 3
  • 3
0
votes
1 answer

how to add series to chart

I am trying add a new chart1 sheet and adding series from sheet1 to my chart1 sheet. Here is my code... Charts.Add With ActiveChart .ChartType = xlLine .HasTitle = True .ChartTitle.Text = "Closing Price" .SeriesCollection.NewSeries …
Sanjeev Shinde
  • 63
  • 1
  • 3
  • 14
0
votes
0 answers

What affects the default value of Textframe.Autosize?

I have some old VB6 code that adds a shape to an Excel chart. ' add a label to display the results Set BoxShape = Chart.Shapes.AddLabel(1, ScaleToPointsX(series, x), ScaleToPointsY(series, y) - 20, 1, 1) …
Phil Preen
  • 589
  • 5
  • 20
0
votes
1 answer

Why is my Excel chart generating a legend that doesn't correspond with the pie chart?

I am generating a basic Excel chart with this code: object misValue = System.Reflection.Missing.Value; //add data _xlSheet.Cells[11, 11] = "PhooBar"; _xlSheet.Cells[11, 12] = "Student1"; _xlSheet.Cells[11, 13] = "Student2"; _xlSheet.Cells[11, 14] =…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Displaying 2 Chart items in the same chart

How can I get this chart to have the quantity of 10 inside the bar of the bar chart and outside of the X-axis?
click here
  • 814
  • 2
  • 10
  • 24
0
votes
2 answers

Excel VBA macro to copy and paste charts works sometimes

I wrote a macro that imports a large CSV data file, organizes the data, and creates charts. The charts are created by: Copy template chart Paste on another tab Rename chart Add data series Repeat for each column of data The problem I'm having is…
Kes Perron
  • 455
  • 5
  • 12
  • 24
0
votes
2 answers

Excel Chart Omitting Additional Data Values on Specific Date

I have a macro which generates a Chart from a range of data. See data below: 2015/08/01 12:49.002 2015/08/01 00:41.600 2015/08/02 00:27.198 2015/08/03 01:05.600 2015/08/03 01:30.599 2015/08/04 02:29.799 2015/08/05 01:40.199 2015/08/06…
Jean-Pierre Oosthuizen
  • 2,653
  • 2
  • 10
  • 34
0
votes
2 answers

How can I add the value (not just the percentage) to an Excel pie chart?

I've got this code: private void WriteChartSheet() { _xlSheetChart = (Worksheet)_xlSheets.Item[2]; if (_xlSheetChart != null) { _xlSheetChart.Name = ProduceUsageChartSheetName; // Contract vs. non-Contract pie chart …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
0 answers

Excel 2010 Bar in Pie Chart - Points in Pie and in Stack Bar (Excel or VBA)

I am trying to achieve a very specific format for a Bar in Pie Chart in Excel 2010. I need the points that are aggregated in the Pie Chart and displayed individually in the Stack Bar to display in the Pie Chart as well. In other words, show the…
0
votes
2 answers

Create chart using RecordSet data in VBA Excel code

I am getting data from Access, copying into Excel sheet and creating a chart using Excel VBA. The data looks like this: And the chart looks like this: I want to show all transactions in sheet but in chart I want to show sum of amount of dates. For…