ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to create a custom line and column chart in excel 2007 (https://www.excelbanter.com/charts-charting-excel/223795-how-create-custom-line-column-chart-excel-2007-a.html)

Jim, Houston

How to create a custom line and column chart in excel 2007
 
I have a custom line and column chart produced in Excel 2003 but when opened
in Excel 2007 the line chart has disappeared, does Excel 2007 support this
type of chart as I cannot find any reference to this subject in the help
search.

Jon Peltier

How to create a custom line and column chart in excel 2007
 
Excel 2007 doesn't offer the old combination charts as selectable types, but
existing charts should be okay. Should be, but 2007 has issues with charts.

It's easy enough to make these charts from scratch. Create the chart as
either a line or column chart with both sets of data. right click on one
series, and choose Chart Type (or is it Change Chart Type) to change the
chart type. Then if you need one of the series on the secondary axis, right
click on it, choose Format, and find where you can select Secondary instead
of Primary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Jim, Houston" <Jim, wrote in message
...
I have a custom line and column chart produced in Excel 2003 but when
opened
in Excel 2007 the line chart has disappeared, does Excel 2007 support this
type of chart as I cannot find any reference to this subject in the help
search.





All times are GMT +1. The time now is 06:59 PM.

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