Excel - COLUMN Function Problem - Expert Solution

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
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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc