How do I do a combination STACKED column and line chart on 2 axis
I want to have a combination chart on 2 axis. I want the columns to be
stacked. I want the line to be on a second Y axis....please help! |
How do I do a combination STACKED column and line chart on 2axis
Hi,
Create the chart using all the data as a stacked column chart. Double click the series that you want as a line on the secondary axis. On the Axes tab select Secondary axis. The right click the series and pick Chart type to change it the required line chart type. Cheers Andy rwtuning wrote: I want to have a combination chart on 2 axis. I want the columns to be stacked. I want the line to be on a second Y axis....please help! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 06:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com