Change individual series from bar to line

[CLK-user1]

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?

[Andy Pope]

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

CLK-user1 wrote:
> 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?
>
>

--

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