Creating custom charts
Does anyone know a way to create a chart that combines the stacked column
chart with a line or scatter chart. I know there is a combo chart but that will not let me use a stacked column |
Creating custom charts
Forget the built-in options. It is easy to make your own combination charts
which can be so much more flexible. Start by making the chart using the predominant series type, in your case, stacked column. Select a series which you want to change to a line type, go to Chart menu, Chart Type, and select the line type you want. Repeat as necessary. To put any series onto a secondary axis, double click on it, and go to the Axis tab. Combination Charts: http://peltiertech.com/Excel/Charts/ComboCharts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Taebaek" wrote in message ... Does anyone know a way to create a chart that combines the stacked column chart with a line or scatter chart. I know there is a combo chart but that will not let me use a stacked column |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com