Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Comparison graph in excell
I am trying to create a Line - Column graph in excel. One that plots a line
series and column series on the same axis. I am getting 2 columns and 2 line series. However i would like to get 3 columns and 1 line series. Can someone tell me how i can to do this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Comparison graph in excell
Select the line series you want to change, go to Chart menu Chart Type,
and change it to a line. If you need to change from primary to secondary axes, double click the series and on the Axis tab make your selection. Next time, ignore the built-in custom chart types, make a line chart, and change the one series to a column. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Anisa" wrote in message ... I am trying to create a Line - Column graph in excel. One that plots a line series and column series on the same axis. I am getting 2 columns and 2 line series. However i would like to get 3 columns and 1 line series. Can someone tell me how i can to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Markers only appearing on comparison line graph | Charts and Charting in Excel | |||
How to lock a line put on a graph in excell | Charts and Charting in Excel | |||
comparison string VBA excell | Excel Discussion (Misc queries) | |||
how to plot two lines on a graph for comparison? | Charts and Charting in Excel | |||
How do I add a bullet to a note on an excell graph. | Charts and Charting in Excel |