Adding 2 y axis to a bar chart

spicoli

New Member
Joined
Nov 18, 2004
Messages
12
Hi -
I have a bar chart that has categories on the y axis. I would like to create a y axis on the right hand side that has the value for each bar.

Any suggestions as to how I can do this?

Thanks :biggrin:
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Without seeing just how you have your data, you could create a chart using two axes by using the wizard and choosing custom types, choose line column on two axes, (or two lines - whichever you want). Highlight your data, then put in all your other information (titles, etc). You can then right click on the line and make it a bar or whatever. Is this what you mean?
 
Upvote 0
Thanks. It looks like I didn't add enough informtation.

My chart looks like this. The bars are horizonatal and positioned on the y axis. The x axis is the range of values for each bar.

I would like to add another axis on the right that contains the value for each category bar.

Thanks
 
Upvote 0
Download the HTML maker (on the bottom of each page) to show your data layout - then people can see how your data is set-up and perhaps come up with an answer to your question.
 
Upvote 0

Forum statistics

Threads
1,219,162
Messages
6,146,659
Members
450,706
Latest member
LGVBPP

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top