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.