Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
I have a table that includes monthly values for several years (January -
December). I am making a line chart that will plot these values. I am trying to figure out if there is a way to include cells in "Source Data" of the chart but not to have them plotted unless tehre is a value in there. Currently it plots August 2008, but then shows a sharp drop for September 2008 and then flat line from there through December 2008. I am trying not to have to update the "Source Data" every time I add a value for the next month... |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
You need a dynamic chart:
http://peltiertech.com/WordPress/200...ynamic-charts/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vanessa" wrote in message ... I have a table that includes monthly values for several years (January - December). I am making a line chart that will plot these values. I am trying to figure out if there is a way to include cells in "Source Data" of the chart but not to have them plotted unless tehre is a value in there. Currently it plots August 2008, but then shows a sharp drop for September 2008 and then flat line from there through December 2008. I am trying not to have to update the "Source Data" every time I add a value for the next month... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal line or target line to Excell 2007 Chart | Charts and Charting in Excel | |||
How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |