Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can create stacked column chart join with line [email protected] Charts and Charting in Excel 1 November 18th 08 09:02 AM
Add a Horizontal Line to a Column Chart in XL 2007 Fabio Coatis Charts and Charting in Excel 6 September 21st 07 06:38 PM
How do I create a stacked column/line chart combination? Cori Charts and Charting in Excel 3 August 2nd 06 03:23 AM
My Custom Line-Column 2 axes Chart dsn't work with +6sets of cells Tim Charts and Charting in Excel 0 August 8th 05 07:07 AM
How do I create a Line-Column on 2 Axis chart that allows more... Angioletta Charts and Charting in Excel 1 December 17th 04 11:56 AM


All times are GMT +1. The time now is 09:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"