Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Cost scale on the Y axis.

2 replies [Last post]
Nick Jackson
User offline. Last seen 12 weeks 3 days ago. Offline
Joined: 12 Jul 2007
Posts: 18
Groups: None

Here's something that's always irritated; is there a solution?!

When making a S curve or histogram on costs, the Y axis is always graduated at an illogical scale, i.e. if you have £1,301,123  as the max value, it graduates into say a 20% division of the budgeted total rather than rounding up on the scale to say, the nearest £100K. This gives the Y axis a strange look when presented to the team.

Is there a workaround?

Replies

Nick Jackson
User offline. Last seen 12 weeks 3 days ago. Offline
Joined: 12 Jul 2007
Posts: 18
Groups: None

Thanks Daniel

Daniel Limson
User offline. Last seen 5 years 38 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None

Hi Nick,

If you want a combine Line and Bar Chart, you should have a time/ Increment data and a Time/Cumulative Data

The bar chart or histogram chart using your incremental data should be based on the Primary Axis and the cumulative chart based on a line curve should be based on the secondary axis. You can switch or define the axis by clicking on the bar or line and then format data series.

Cheers,

Daniel