If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change data Series from a bar to a line after changing axis
I have a two y axis bar line pivot chart. The default put the data on the
wrong axises. I changed them to the proper axis, but how do I change them from a bar to a line and vise versa? (right now the data I want as a bar is a line and the data I want as a line is a bar) |
#2
|
|||
|
|||
Change data Series from a bar to a line after changing axis
You can select a series, then go to Chart menu Chart Type, and select a
type that will be applied just to the selected series. Next time, instead of using the inflexible built-in custom types, make your own custom type. Make the chart as a column chart with all series, then using the technique above change the ones you need to line, then double click the ones you want to change to the other axis, and adjust the selection on the Axis tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Aaron" wrote in message ... I have a two y axis bar line pivot chart. The default put the data on the wrong axises. I changed them to the proper axis, but how do I change them from a bar to a line and vise versa? (right now the data I want as a bar is a line and the data I want as a line is a bar) |
Thread Tools | |
Display Modes | |
|
|