Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I understand the default for col-line charts is col on the primary y axis,
line on the secondary axis. I am trying to chart 4 series (columns) onto the primary and 1 series (line) onto the secondary axis. The chart wizard always starts with placing 3 series onto col / 2 series onto lines. I can change one of the line series to the primary axis but it still does not format the data into a "column" but remains as a "line". any suggestions. Thanks. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Bag the built-in custom chart types. Make a column chart with all of your
data. Select the series you want to change. Go to Chart menu Chart Type, then select a line type you like. Double click on the new line series, and on the Axis tab, select Secondary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "john" wrote in message ... I understand the default for col-line charts is col on the primary y axis, line on the secondary axis. I am trying to chart 4 series (columns) onto the primary and 1 series (line) onto the secondary axis. The chart wizard always starts with placing 3 series onto col / 2 series onto lines. I can change one of the line series to the primary axis but it still does not format the data into a "column" but remains as a "line". any suggestions. Thanks. |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
thanks. works great.
"Jon Peltier" wrote: Bag the built-in custom chart types. Make a column chart with all of your data. Select the series you want to change. Go to Chart menu Chart Type, then select a line type you like. Double click on the new line series, and on the Axis tab, select Secondary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "john" wrote in message ... I understand the default for col-line charts is col on the primary y axis, line on the secondary axis. I am trying to chart 4 series (columns) onto the primary and 1 series (line) onto the secondary axis. The chart wizard always starts with placing 3 series onto col / 2 series onto lines. I can change one of the line series to the primary axis but it still does not format the data into a "column" but remains as a "line". any suggestions. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combine Column & line charts | Charts and Charting in Excel | |||
Line - Column Charts | Charts and Charting in Excel | |||
Line-Column Charts | Charts and Charting in Excel | |||
Column & Line Charts | Charts and Charting in Excel | |||
Line /Column Charts | Charts and Charting in Excel |