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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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,220,965
Messages
6,157,119
Members
451,398
Latest member
rjsteward

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