Change individual series from bar to line
 

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?


--
CLK-user1
------------------------------------------------------------------------
CLK-user1's Profile: http://www.excelforum.com/member.php...o&userid=36551
View this thread: http://www.excelforum.com/showthread...hreadid=563030

Change individual series from bar to line
 

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