Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
combine Column & line charts
I am trying to create a chart that shows Total AR as a column and % over 30 &
over 60 as lines. I've tried to use the Line-Column but it only plots one of the % data and not both. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
combine Column & line charts
Those "built-in custom" charts are a pain.
Make a column chart with all three series. Select the Over 30 series, and use Chart menu Chart Type to change it to a line type. Repeat this for the Over 60 series. If you want the percentages on the secondary axis, double click the Over 30 series, and on the Axis tab, choose Secondary. Repeat for the Over 60 series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "C" wrote in message ... I am trying to create a chart that shows Total AR as a column and % over 30 & over 60 as lines. I've tried to use the Line-Column but it only plots one of the % data and not both. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
How to Combine a Floating Column Chart with Line? | Charts and Charting in Excel | |||
Combine stacked column and line chart w/series lines | Charts and Charting in Excel | |||
Line - Column Charts | Charts and Charting in Excel | |||
How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel |