asked on

Chart help, labeling axis

Experts,

I am need to get the lable in the attached to be on the Y axis.

Maybe this is not that difficult but I do not know how to do this.

thank you

please see attached.
Ratings-Banks-test.xls

ASKER CERTIFIED SOLUTION

Rartemass

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Echo_S

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pdvsa

ASKER

OK I see the text box. I think that is a temporary solution but I was looking for some other way around a text box. The data will continually change and I want the graph to move dynamically with the data in the table.

I downloaded the XY labeler that labels axis but I dont think it is a solution. I am not too familiar with it though.
http://www.appspro.com/Utilities/ChartLabeler.htm

i also tried to add a secondary axis but the letters dont plot...excel turn the letters (AA+ / Aa1) into numbers so it seems impossible to plot letters along the axis.

What do you suggest now?

pdvsa

ASKER

Echo, didnt see your post. sorry. I am checking out the page now. will revert. It is seems like a PITA then I am sure it will be difficult for me.

thanks....will come back soon.

Echo_S

It might not be quite as difficult as you might expect. Rob's labeler will make it easier -- good that you have that already. Hopefully the example XLS file on the page will also help.

pdvsa

ASKER

oh boy that is diabolically confusing. Maybe you can take a crack at it. I have blown a fuse trying to apply to my data set. I downloaded the zip file and looked at it but it is a hard read and not so user friendly to a low level user at least in my opinion.

thank you. i might have to end up applying the text box trick from Rartemass. I wish I had 2013.

Echo_S

Ah, unfortunately I don't have time to play with this much today and my quick attempt proved that this way is more than just "fiddly" with your specific chart data! I think I'd go with Rartemass's textbox for this one.

Apologies -- didn't mean to derail you or anything by suggesting that.

Rartemass

Echos solution is one possibility but is tricky as specified. In the short term I don't think Excel can do what you require. Excel 2013 may provide the answers but before that...
The issue is mainly what you want for the labels, the combination alphanumeric and slashes stuff Excel up.
Sorry but the doesn't seem to be a good answer for you.

pdvsa

ASKER

thank you. I will go with the text box method from rartemass...and hopefully will get 2013 sometime soon!

Echo_S

Totally agree, Rartemass.

Just as an aside, Excel 2013 won't do what you need, pdvsa. It does have an easier-to-access text option for the X-axis, but not for the Y (scale) axis.

pdvsa

ASKER

oh I see. darnit. thank you though...