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... |
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... |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com