| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| How do I stop Series Line from Dropping to Zero | Excel Discussion (Misc queries) | |||
| Series order conflicts with line order | Charts and Charting in Excel | |||
| ? change default line style from solid to dotted | Excel Discussion (Misc queries) | |||
| Add series to line graph | Charts and Charting in Excel | |||
Linear Mode
