Creating custom charts in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When creating charts in earlier versions in Excel, it was possible to select
a custom type of a column chart with one series displayed as a line. I can't
find this in Excel 2007 - is it still there somewhere?
Any help would be gratefully received!
 
As always, you can build your own custom chart. (The built-in custom ones
are not too flexible anyway.) For example, to make a line-column chart, make
a line chart, then right click on a series, choose Chart Type from the
pop-up menu, and choose the column chart type for the selected series.
Repeat as needed. To put a series onto the secondary axis, right click on
the series, choose Format Series, then choose Secondary.

- Jon
 
Unfortunately I think the built-in custom chart types were more of a crutch.
MS could do more to inform users that individual series can be typed
independently.

- Jon
 
Back
Top