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
2
votes
0 answers

Hiding mouseover tooltip in charts

I would like to know how can I make it so that a chart doesn't show the data point value on hover. The chart in question plots a range with formulas so I can toggle all the series, and I need the solution to be on the file so that no one can see the…
Alessandro
  • 71
  • 1
  • 5
2
votes
4 answers

Graphing blank cells in form of gaps in Excel

I'm graphing a set of data that has blanks in some cells. In the blank cells I have formulas and I have to keep the formulas. When I graph the data, the blank cells are graphed as zeros. I'd like to put gaps instead of zeros in the graph. I tried…
Sara E
  • 325
  • 3
  • 6
  • 13
1
vote
0 answers

Why does my embedded chart cause Excel to crash if I don't open VBA first?

I have an embedded chart on a protected Excel sheet that I would like to process chart events on (MouseMove and MouseDown), but Excel crashes when I click on the chart unless I first open the VBA editor. If I don't open VBA and click on the chart,…
matt7
  • 11
  • 3
1
vote
1 answer

VBA Chart resize code not working with error: the shape is locked and cannot be resized

I have finally found a code that meets my needs to create a chart (Code below). However I have two problems with that: 1- Worst thing is that every time I run the code it makes 2 sheets on my workbook. One contains a blank chart frame and one…
shahin syr
  • 33
  • 5
1
vote
1 answer

How can I get my Excel spill range to be grouped by a specific column for a chart?

I need to produce a chart in Excel to show a quantity of items for a number of categories, grouped by the month they were received. At the moment, every occurrence of the Month shows up in my clustered column chart. I can manually do a table and…
Jayce
  • 539
  • 6
  • 21
1
vote
1 answer

Label the last value in chart

I was trying to create a VBA in Excel to avoid the probem of last labelled value in progress chart. I have several chart in a Dashboard and every time I update the progress with the new value I have to select the last value and add a label to the…
Ivett0606
  • 11
  • 2
1
vote
0 answers

Excel Chart Tooltip text change

I have added a chart to excel using Add-ins, however I am unable to find a property/method to set its tooltip. As can be seen in image below, current tooltip text is 'Series "Year:" Point "2014"'. I want to remove words series and point from it to…
1
vote
1 answer

How to break area chart in excel

I've been trying to create a separated "broken" area chart. The top chart is the desired outcome and the table attached is the data populating it. Do you know what is the best way to achieve the desired result? [1 thanks alot !
Nimrod
  • 11
  • 1
1
vote
0 answers

Invalid name for Parameter for FullSeriesCollection

I've been using curves names that have a "Δ" as the first character [CharW(916)] in the name, this has not caused any problem until recently. The code snippet below worked fine in the past, but for the "last few months" -- can't be more definite --…
Peter Day
  • 11
  • 1
1
vote
2 answers

VBA Change Line Color of Chart with ColorIndex

The code below works and sets the color of the four lines with the three values for rgb. The three rgb values are filled in an array (Clr) which is not very clear. Is there an alternative way for instant by using Hex numbers, ColorIndex or the…
musbach
  • 558
  • 1
  • 9
  • 29
1
vote
1 answer

Dynamic update of chart-series using a dynamic range

I am trying to update charts using VBA. I have a timeseries that I update ad-hoc. I wish to update the chart using VBA. When I get to the chartobjects it errors. Both the chart and the series have names: Dim tsEURLengde As Integer Dim rngEUR As…
NolsN
  • 25
  • 4
1
vote
3 answers

Restore chart default colours after deleting series

Hi I can't believe I can't find an answer to this but I have looked. In Excel I want to restore the default colour palette order to a chart that I have deleted some series from. Ie if my colour palette goes: red, green, blue, yellow, orange,…
Sarah
  • 3,022
  • 1
  • 19
  • 40
1
vote
1 answer

Create Chart side by side using for loop

I am trying to create 3 charts that I want to put side by side using a for loop but every time I run the loop multiple charts poop up but with no data on them. Dim MyChart As Chart Dim MyChart2 As Chart Dim MyChart3 As Chart Dim DataRange As…
1
vote
1 answer

ChartObject Runtime Error that suddenly appears after month

I am trying to create a Chart. Once it worked. Tried it again some weeks later and now error in this following first line. It says "Runtime error 1004 - Application or object-defined error." in Line Set Co = Work..... There is more code to the…
1
vote
1 answer

Change chart from cell ranges to named range

is there a way to do vba by updating the chart data series from cells range to named range, because when i move and copy to a new sheet in the same workbook it changes back to cells range. When i move and copy to another sheet it will change to…
noel
  • 31
  • 5