ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how does one plot a line-column on two axes in excel? (https://www.excelbanter.com/charts-charting-excel/157425-how-does-one-plot-line-column-two-axes-excel.html)

gbrunnhoeffer

how does one plot a line-column on two axes in excel?
 
How does one use Excel 2007 to plot a line and a bar graph with two axes -
the same chhart offered in Excel 2003 under Custom Types?

Andy Pope

how does one plot a line-column on two axes in excel?
 
Hi,

You have to build the combination chart yourself.
Create a column chart based on both data sets. Select the column you want as
a line and use Change Chart Type to set it to line chart.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"gbrunnhoeffer" wrote in message
...
How does one use Excel 2007 to plot a line and a bar graph with two axes -
the same chhart offered in Excel 2003 under Custom Types?




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

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