Home |
Search |
Today's Posts |
#1
|
|||
|
|||
charts
Hi,
I need some help creating a chart with two lines and one column. I have already created a Line - column on 2 axis, but i cannot figure out how to do 2 lines with 1 column on the same chart. An example of data i need charted: Q1 Q2 Q3 Q4 volume(units) 100 200 250 300 price1($) 10.00 11.00 11.25 11.45 price2($) 11.00 10.80 10.65 From this data i already have the volume and price1, but when i try to add price2 the data for price1 doesn't remain a line. Can anyone help? thanks... |
#2
|
|||
|
|||
Let XL do whatever it wants. Then, select each of the plotted series
that is not the way you want and select Chart | Chart Type... and pick the desired type of chart. When a single series is selected, the chart type change affects only the selected series and not all the series. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi, I need some help creating a chart with two lines and one column. I have already created a Line - column on 2 axis, but i cannot figure out how to do 2 lines with 1 column on the same chart. An example of data i need charted: Q1 Q2 Q3 Q4 volume(units) 100 200 250 300 price1($) 10.00 11.00 11.25 11.45 price2($) 11.00 10.80 10.65 From this data i already have the volume and price1, but when i try to add price2 the data for price1 doesn't remain a line. Can anyone help? thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
Some charts don't show | Charts and Charting in Excel | |||
i need help automating, or at least simplifying, my charts | Charts and Charting in Excel | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel |