ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Creating custom charts (https://www.excelbanter.com/charts-charting-excel/120313-creating-custom-charts.html)

Taebaek

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

Jon Peltier

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