Format Secondary Axis to PERCENT

[domgilberto]

Man.... sometimes I want to pull my hair out...

Please Login or Register  to view this content.

Why does this not work!?

run-time error '-21476 bla bla bla....

[MrShorty]

Doesn't the percent need to be in quotes like the previous statement ....numberformat="percent"?

[Olly]

Try:

Please Login or Register  to view this content.

[domgilberto]

Try:

Please Login or Register  to view this content.

Thanks for your input, but nope... i tried this (screenshot: http://screencast.com/t/QZycmSAERUNq)

Exactly the same error...

[Olly]

You do have a secondary category axis, right? You're not trying to change the secondary VALUE axis?

Maybe attach your workbook....

[Winon]

I would first try:

Please Login or Register  to view this content.

Followed with;

Please Login or Register  to view this content.

[domgilberto]

You do have a secondary category axis, right? You're not trying to change the secondary VALUE axis?

Maybe attach your workbook....

Hm... you know what, I think this maybe where im going wrong. I would attach my sheet but it's massive.

Literally this is everything I am doing here:

Please Login or Register  to view this content.

[Olly]

So is it a secondary x-axis, or the primary y-axis that you are trying to format as percent?

If it's the y-axis, then change that line to:

Please Login or Register  to view this content.

[domgilberto]

So is it a secondary x-axis, or the primary y-axis that you are trying to format as percent?

If it's the y-axis, then change that line to:

Please Login or Register  to view this content.

I know this may come across strong considering we're on a forum talking about VBA logic; but I love you...

One of those days where you're staring at an issue right under your nose.

On this topic:

Please Login or Register  to view this content.

This works fine, however the underlying data is time duration in a fraction (e.g. 4208.28 - 4207.28). I want to illustrate MM:DD:HH however charts dont seem to like this?

[Olly]

Glad that helped!!

If you want the x-axis labels formatted as "MM:DD:HH" then try:

Please Login or Register  to view this content.

[domgilberto]

Glad that helped!!

If you want the x-axis labels formatted as "MM:DD:HH" then try:

Please Login or Register  to view this content.

Superb - thank you so much. I was nearly there. I was doing "MM:DD:HH". Not sure why this doesnt work this way?

Kudos to you!