If you look at the logic of what your trying to display, 25,000 against 5, how would you expect the columns to display?
Hi Sorry to be a pain.
I guess all i need is a logharithm which will also work for negative numbers. If this can't be done easily by formatting or formula then can you please help with VBA coding.
P.s Does anyone know why the Logharithm has not been considered to work for Neg values also and why is there not a built in function which could handle if values were alot higher than other values?
Many Thanks
Hi Sorry to be a pain.
I guess all i need is a logharithm which will also work for negative numbers. If this can't be done easily by formatting or formula then can you please help with VBA coding.
P.s Does anyone know why the Logharithm has not been considered to work for Neg values also and why is there not a built in function which could handle if values were alot higher than other values?
Many Thanks
Please guys,
Any luck
I didn't think the chart part would have been such a pain
Your not getting many responses for a reason, what you want isn't really feasible. Take a picture of a double deck bus that has a model car scale 5/25000 beside it, take it so that you get both the bus and car in the same picture and once you print out the pic you'll see theres no sign of the car.
The only way would be in upping your 5 to something like 500, or more till you get it visible on your chart then play with the formatting so that the legend looks like 5. Whats increments is showing?
You could plot the smaller numbers against a secondary y axis.