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
1 answer

Multiple axis excel 2010 chart

I´d like to create excel chart with multiple axis x using dynamic - offset defined range. I have columns A, B, C - for multiple axis. If I define this as a range e.g A2:C50 then the items (values) in the rows are ordered to multiple axis (horizontal…
lech
  • 1
0
votes
0 answers

Excel Pivot chart clears Data Labels when refreshed

I have two identical Pivot Charts (same chart template) on two different data sources. When I hit refresh all both have new data, first one with retained formatting and the second one is missing data labels (usually not all of them but randomly 1 or…
0
votes
0 answers

How to set minimum axis values in Excel 2007 based on cell value?

Is it possible to set minimum axis values in Excel 2007 based on cell value? For example, I would like to put a value into a cell and match the beginning point X Axes chart's to that value without Macro. Any help would be appreciated.. thank you!
susiana
  • 43
  • 2
  • 8
0
votes
2 answers

excel bubble chart overlapping data label

I am facing an issue with a bubble chart when criteria1 and criteria2 in the below table have the same values. The data label and data series overlap each other. In such cases making it difficult to read them. How can this be…
Santosh
  • 12,175
  • 4
  • 41
  • 72
0
votes
1 answer

Chart SetSourceData fails - Object doesn't support this property or method

The following statement fails: wksGraphTotal.ChartObjects("TotQuestion").SetSourceData Source:=wksGraphTotal.Range("$A$2:$C$62") Object doesn't support this property or method But if I click on the chart and choose "Select Data" in the Excel…
user1283776
  • 19,640
  • 49
  • 136
  • 276
0
votes
1 answer

Step-chart in Excel

I am trying to create step-chart in Excel using tutorial (section "Step Chart Approach 2: Line Chart with Repeated Ranges"). However, it works incorrectly. According to instructions (section "How it Works") values from 2 named ranges should be…
Shurov
  • 400
  • 1
  • 9
  • 20
0
votes
1 answer

Switch Row/Column (switch axes) in xlsio chart (syncfusion)

I am looking for a way to switch between axes of the chart being generated with Syncfusion XlsIO library. I was not able to find any solution due to the library being commercial and less used, and the Knowledge Base being very limited. Basically, I…
Cyberpks
  • 1,401
  • 6
  • 21
  • 51
0
votes
0 answers

Format Excel chart: white title on blue background, data point labels on coloured circles of size proportional to value

How do I recreate the following chart/image? I don't know how to create a border with the padded header etc.
egg
  • 373
  • 1
  • 7
  • 15
0
votes
1 answer

C# Excel Chart can't set serie scale

I'm trying to draw a threshold (1 line from left to right). To do so I add the threshold value twice and the value 0 and 1 for xValues then set the scale of X to be from 0 to 1. public static void AddThreshold(Chart xlChart, double value, string…
Mihai Bratulescu
  • 1,915
  • 3
  • 27
  • 43
0
votes
1 answer

Excel 2010 dynamic named range is replaced with the calculated range

I am trying an experiment using a series of dynamic named ranges to generate a series of charts under Excel 2010 (Microsoft Office Professional Plus 2010). The problem I am running into is that the name of the dynamic range gets replaced by that…
David R.
  • 1
  • 2
0
votes
1 answer

Dynamic excel chart doesn't display all of the data

I have this code that allows users to enter chart parameters into some cells and dynamically create a chart. Many series (up to four) are allowed on two vertical (y) axis and one shared horizontal (x) axis. The chart is a mixture of columns and…
Matt Cremeens
  • 4,951
  • 7
  • 38
  • 67
0
votes
1 answer

Excel - Add a single horizontal "target line" to the horizontal axis

I have a X Y (Scatter) chart in Excel that is currently displaying two data sets exactly as I want them. Is it possible to add a single "target" line at a point of my choosing across the X access? So let's say the Y axis is 0% up to 100%. let's say…
Ferdia O'Brien
  • 867
  • 3
  • 10
  • 25
0
votes
1 answer

Same colours in Pie Chart as in Column Chart

I have two charts on the same sheet, one pie, one column. They show the same titles, from the same rows but data from different columns. (there may be up to 100 data series or slices) in the charts. I need to make them use the same colours for the…
M. H
  • 199
  • 3
  • 5
  • 13
0
votes
1 answer

How to change Orientation of bars in Excel Bar Chart created with VBA

I am creating a chart, in a form, using VBA Excel 2010. I have configured excel to use Chartspace and the chart is created using dynamic data correctly, but the presentation is not what I am looking for, but can't figure how to change it. Please see…
cquadrini
  • 769
  • 2
  • 12
  • 25
0
votes
2 answers

custom chart data labels based on raw number not %

I have a pivot chart that shows the % of a field as the value, but I would like the label to be a combonation of the % and the ran number the % is based on. Current: What I would like: The % number is easy because when I loop through the data…