**Question description:**

*This user has given permission to use the problem statement for this blog.*

I'm attempting to add a secondary axis for a clustered 3d column chart - I've seen online a suggestion of going to the design ribbon after selecting the chart and selecting add chart element - I don't see where the add chart element command is

Solved by F. Q. in 39 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
04/04/2018 - 05:28

Hi there

User
04/04/2018 - 05:28

Hi

Excelchat Expert
04/04/2018 - 05:28

How are you and how may i assist you with today?

User
04/04/2018 - 05:30

I'm attempting to add a secondary axis (vertical and horizontal, horizontal being a 2 level category axis) to a clustered 3d bar chart, and when I go to the design ribbon in excel 2010 after selecting the chart, I don't see any add chart element anywhere, contrary to what online instructions and excel help indicate should be done

Excelchat Expert
04/04/2018 - 05:30

Okay, i will try my best to help you out with this

Excelchat Expert
04/04/2018 - 05:30

Can you share me a sample worksheet

Excelchat Expert
04/04/2018 - 05:30

So that we both can have a better evaluation to the issue

User
04/04/2018 - 05:30

It's company confidential data

User
04/04/2018 - 05:30

I can't

User
04/04/2018 - 05:31

I can tell you generally the organization of the data

Excelchat Expert
04/04/2018 - 05:31

Okay, you can randomize the data and can send it over as we also assure confidentiality on you data

User
04/04/2018 - 05:32

The data itself has 1 column that is a high level category, the 2nd column is a lower level category, and the 3rd through the 5th column have column headers representing 3 series that are being plotted as columns in a clustered column chart

User
04/04/2018 - 05:33

all the other cells under columns 3 through 5 are the data points - dollar figures

Excelchat Expert
04/04/2018 - 05:33

okay, as per your description as i can understand that you need to add a new/additional chart element right?

User
04/04/2018 - 05:34

correct, a secondary horizontal category axis

Excelchat Expert
04/04/2018 - 05:34

so this can be done in "All chart type" option in excel

User
04/04/2018 - 05:34

my understanding is in order to add a secondary horizontal category axis, I will need to first add a secondary vertical axis which I can make invisible, since I have no need for the secondary vertical axis

Excelchat Expert
04/04/2018 - 05:35

if you can't see it in the excel ribbon then you have to add it using the customize ribbon option

User
04/04/2018 - 05:36

How do I customize the design ribbon to add the add chart element function?

User
04/04/2018 - 05:36

Never mind

User
04/04/2018 - 05:36

I see how

Excelchat Expert
04/04/2018 - 05:36

Okay , greay!, i will help you with that

User
04/04/2018 - 05:36

I pulled up the context menu for the ribbon and selected customize ribbon

Excelchat Expert
04/04/2018 - 05:37

great!

User
04/04/2018 - 05:37

let me see if there is an option to add the add chart element function to the ribbon one moment

Excelchat Expert
04/04/2018 - 05:38

i will give you the screenshot :)

Excelchat Expert
04/04/2018 - 05:39

there you go

[Uploaded an Excel file]

Excelchat Expert
04/04/2018 - 05:41

is it nice

User
04/04/2018 - 05:44

When I add all chart types to a custom group in the layout ribbon, and select it, it just prompts me to change the chart type

User
04/04/2018 - 05:45

I don't see anything that lets me add a chart element

Excelchat Expert
04/04/2018 - 05:47

okay for that right click on the chart and select "change chart type" option from the drop down

User
04/04/2018 - 05:47

And then what?

Excelchat Expert
04/04/2018 - 05:50

then select the appropriate option as above making sure the data is selected to appear in the chart.

[Uploaded an Excel file]

Excelchat Expert
04/04/2018 - 05:53

see how i changed the same chart

[Uploaded an Excel file]

User
04/04/2018 - 05:54

In the change chart type for excel 2010 I don't see custom combination

Excelchat Expert
04/04/2018 - 05:54

so there may find many different option to this

User
04/04/2018 - 05:54

or rather I don't see combo as your graphic shows

Excelchat Expert
04/04/2018 - 05:54

okay then you might need to update the excel version

User
04/04/2018 - 05:55

I have excel 2010

User
04/04/2018 - 05:55

shouldn't that support 2 axes?

User
04/04/2018 - 05:55

according to the help function of excel 2010, it should be possible to add a secondary axis

User
04/04/2018 - 05:55

but it is not clear how

Excelchat Expert
04/04/2018 - 05:56

yep m really not sure as this is mu excel 2016

User
04/04/2018 - 05:56

the instructions say to select the add chart element function, but I can't find that function anywhere

Excelchat Expert
04/04/2018 - 05:56

can you see the "All Chart Type

Excelchat Expert
04/04/2018 - 05:56

option

Excelchat Expert
04/04/2018 - 05:56

in the ribbon of 2010?

User
04/04/2018 - 05:57

all it does is bring up the change chart type dialog

User
04/04/2018 - 05:57

and in that dialog, I have no option for combo, and I have no option to add a secondary axis

Excelchat Expert
04/04/2018 - 05:58

ooppps, then i guess seriosly you need to update the version, and if you have corporate ID then you can get it in free@

User
04/04/2018 - 05:59

The point is I should be able to do it in Excel 2010, and I don't have time to negotiate an upgraded version of excel - I need an answer of how to do it in excel 2010

Excelchat Expert
04/04/2018 - 06:00

Yes, i understand that but as there is no option in it then how it can be done?

Excelchat Expert
04/04/2018 - 06:01

try to right click on the chart element of present chart and then select "Chart Chart type"

User
04/04/2018 - 06:01

Let's end this conversation - there obviously is a way or it wouldn't be in the help function of excel 2010

User
04/04/2018 - 06:01

But you don't know it so you can't help me

Excelchat Expert
04/04/2018 - 06:01

see if that helps

User
04/04/2018 - 06:01

I'll reach out to someone else

Excelchat Expert
04/04/2018 - 06:02

i would try best but only if i have the appropriate data and the options to do so

Excelchat Expert
04/04/2018 - 06:05

Are you there?

User
04/04/2018 - 06:06

As I mentioned, let's end this, we're not getting anywhere - I'll reach out to someone who knows Excel 2010 better

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*