Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Plotting lines in pivot chart
Excel2003 SP2
I have 3 worksheets with data in a table to show when we are going to run out of numbers. There are three scenarios which show different rates of consumption all crossing the "0" X-axis at different dates. When I change the chart type from 'bar' to 'line' its fine. When I add the second and third scenarios, the data point seems to connect to one another giving a zig-zag affect. How can I get rid of the affect without turning off lines and how can I show different colors for the three lines? Thanks in advance for any/all suggestions. -- Thanks for your help, QAFB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting A Chart From One Variable | Charts and Charting in Excel | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel | |||
Bubble Chart Plotting | Charts and Charting in Excel | |||
Plotting 4 dimensions in a chart | Charts and Charting in Excel | |||
scatter chart insists on plotting as a line chart | New Users to Excel |