ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Column-line chart on two axes (https://www.excelbanter.com/charts-charting-excel/205135-column-line-chart-two-axes.html)

Mary Ann

Column-line chart on two axes
 
How do I do this in Excel 2007. There used to be a custom chart in 2003 €“ is
there still in 2007?

Bernard Liengme

Column-line chart on two axes
 
Make a column chart
Select one of the data series in the chart; change Chart Type to Line
Then format it to have secondary axis
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mary Ann" wrote in message
...
How do I do this in Excel 2007. There used to be a custom chart in 2003 -
is
there still in 2007?




Mary Ann

Column-line chart on two axes
 
Thank you - works a treat!

"Bernard Liengme" wrote:

Make a column chart
Select one of the data series in the chart; change Chart Type to Line
Then format it to have secondary axis
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mary Ann" wrote in message
...
How do I do this in Excel 2007. There used to be a custom chart in 2003 -
is
there still in 2007?






All times are GMT +1. The time now is 04:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com