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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"glitterbug99" wrote in message
...
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!

That's great, thank you! I didn't know you could change types for specific
series.

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"glitterbug99" wrote in message
...
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!

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"glitterbug99" wrote in message
...
That's great, thank you! I didn't know you could change types for specific
series.

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"glitterbug99" wrote in message
...
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!