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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
Custom Charts in Excel 2007 3
How to create a custom line and column chart in excel 2007 1
Not plot a data series in a chart but still display in data table 1
Overlay charts in 2007 2
using office 2007 chart in office 2003 2
Chart sheet in Excel 2007 2
Delete chart's custom number format? 6

Back
Top