Secondary Axis Correction


I've worked with the solution and am still having a challenge with the secondary (far left - Vertical axis).  If you look again at your answer, the Vertical Axis is not consistent (i.e. from % to number).  Can you tell me how to fix the right vertical axis to correspond with the "difference"?

Thank you,

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:

Have you tried right-clicking the secondary axis, and changing the number format?

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
'morning Bright.

Remember, the labels for this axis (it's on the right, by the way, at least in NZ :-) -- maybe it's upside down for you? ) are really data labels for a series. The labels you see are still the original labels from the example chart. You need to run the Chart Labeler tool again and re-assign the label values.

Click the chart  - go to Add-ins Ribbon - XY Chart Labels - Add Chart Labels - select series "diffLabels" - select label range Results!$P$5:$P$40 - set Label Position to Right and OK.

Complete the formula in column P, i.e copy it down to row 40. You may want to change the number format for column P to show a blank cell instead of a dash for zero values. If you want to keep the other formats, then that would be custom format

_(* #,##0.00_);_(* (#,##0.00);_(* ""??_);_(@_)

I would prefer a percentage, like


but you will find what suits you best.

see attached.

cheers, teylyn

Bright01Author Commented:
I have an "Add-Ins" tab but nothing in it.  Right click, left click, I can't get a menu to access the label add-in.  Any ideas?
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
I thought you had the Add-in installed.

This is one of the most valuable tools if you work with charts a lot. It is called XY Chart Labeller, but it creates labels for all kinds of charts. It's free, it works, it's being used by charting experts all over the world.

Download from here and install the Add-in, then the commands will be available on the Add-in ribbon.
Bright01Author Commented:
I'm going to ask you a very stupid question here.  I installed the Add-In.  It doesn't show up in my Add-In Ribbon.  How do I install it within Excel 2007?
Thank you,
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Bright, as they say: there are no stupid questions.

Click the Office button
click Add-ins
in the Manage drop down select Excel Add-ins and click Go
if the XY Chart Labeler 7.0 does not appear in the list of the next dialog, click Browse, browse to the .xla file you downloaded and click OK
Then check that the Chart Labeler is ticked in the list of Add-ins and click OK.

Now back in the sheet, select the Add-ins ribbon, where you will now find the XY Chart Labels command.

Note that the commands available under the XY Chart Labels dropdown differ, depending on whether you have a chart selected or not.

Does that help?

cheers, teylyn


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:
It worked!  Thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.