Change individual series from bar to line

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CLK-user1 - 19 Jul 2006 21:09 GMT

I have created a chart with a secondary y axis, but now I need to change
how each series is displayed. I thought it would be possible to
highlight an individual series (bar in this case) on the chart, then
change the display from bar to line for that series only. I do not see
this option anywhere. Anybody know how to solve this?

Signature

CLK-user1

Reply to this Message

Andy Pope - 21 Jul 2006 12:56 GMT

Hi,

You select the series and right mouse click. On the popup context menu
should be the Chart Type... option.

Not all chart types can be combined though.

Cheers
Andy

> I have created a chart with a secondary y axis, but now I need to change
> how each series is displayed. I thought it would be possible to
> highlight an individual series (bar in this case) on the chart, then
> change the display from bar to line for that series only. I do not see
> this option anywhere. Anybody know how to solve this?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message