| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create combo chart 2007
I now have Excel 2007 and what used to be easy is not so in many cases. One
of these cases is the creation of a combo chart - a set of 3 columns that are represented by bars and 1 column represented by a line with a seperate axis. I know I've done it before, I think they were even 3D bars, but now when I try to change the series it changes the whole chart. HELP! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Create combo chart 2007
Hi,
To change the chart type you need to select as single series first. If it's a 3d type then you are, and always have been, out of luck. 3d types do not do combinations. Cheers Andy Johnny G wrote: I now have Excel 2007 and what used to be easy is not so in many cases. One of these cases is the creation of a combo chart - a set of 3 columns that are represented by bars and 1 column represented by a line with a seperate axis. I know I've done it before, I think they were even 3D bars, but now when I try to change the series it changes the whole chart. HELP! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Create combo chart 2007
And I was blaming 2007... Sorry, my bad. Thanks Andy
"Andy Pope" wrote: Hi, To change the chart type you need to select as single series first. If it's a 3d type then you are, and always have been, out of luck. 3d types do not do combinations. Cheers Andy Johnny G wrote: I now have Excel 2007 and what used to be easy is not so in many cases. One of these cases is the creation of a combo chart - a set of 3 columns that are represented by bars and 1 column represented by a line with a seperate axis. I know I've done it before, I think they were even 3D bars, but now when I try to change the series it changes the whole chart. HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create combo box in excel | Excel Discussion (Misc queries) | |||
| how to create a combo box in excel - how to create the drop down . | Excel Discussion (Misc queries) | |||
| How can I create Combo list with no VBA | Excel Discussion (Misc queries) | |||
| Create a combo chart with two of the same chart types | Charts and Charting in Excel | |||
| create dropdown menu using Combo box | Excel Worksheet Functions | |||
Hybrid Mode
