Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed | Charts and Charting in Excel | |||
Adding more series to 2 axis line graph | Excel Discussion (Misc queries) | |||
Changing Y Axis Scale with percentages (Line Graph) | Charts and Charting in Excel | |||
Combination chart: primary data labels obscure line series on secondary axis | Charts and Charting in Excel | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |