Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I created a graph with a dual axis. I want the first three data sets
to go off of the first axis and the fourth to go of the second axis. I was able to do this but I also want the first three to be bars and the fourth to be a line. The graph is austomatically making the first two bars and the second two lines. How can I change the lines? I appreciate all assistance |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Next time ignore the inflexible built-in chart types. Make your chart with
one kind of series, then select each that you want to change, go to Chart menu Chart Type, and pick the type you want. Later you can double click each you want on a secondary axis, and change the axis on the axis tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "japc90" wrote in message ... I created a graph with a dual axis. I want the first three data sets to go off of the first axis and the fourth to go of the second axis. I was able to do this but I also want the first three to be bars and the fourth to be a line. The graph is austomatically making the first two bars and the second two lines. How can I change the lines? I appreciate all assistance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change data Series from a bar to a line after changing axis | Charts and Charting in Excel | |||
Adding more series to 2 axis line graph | Excel Discussion (Misc queries) | |||
Line Graph: Differences between series | Charts and Charting in Excel | |||
Add series to line graph | Charts and Charting in Excel | |||
How do I add one line series to a bar graph? | Charts and Charting in Excel |