Chart - Width Of Bars in Bar Graph 2

[PhilMyWallet]

I have a chart which has week commencing on the x axis. When I show this as a bar chart the width of the bar is too thin.

I have found this is due to the base unit being set to days, rather than weeks, (therefore the graph makes space for 7 days between each bar)however there is no option to change this to weeks. It is only possible to select Days, months or years.

Is there a solution to this?


Phil

 

[GlennUK]

Show an example of data, and what charting options you used to make the chart.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[PhilMyWallet]

Here you go

 

[GlennUK]

I see what you mean. I haven't done a chart like that in many years, and I'm sure that axes didn't behave like that in old versions. Anyway, to convert the axis from assuming dates and screwing up your spacing, convert the dates to text ( or have a new column for x-axis categories with text verions of your dates ), and you should see an improvement.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[PhilMyWallet]

The simplest solutions are sometimes the best.


Thanks. Worked a treat !!!

 

[GlennUK]

My pleasure! :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

Look at the Chart Options - Axes

There are THREE option button choices for the x-axis...

Automatic
Category
Time-Scale

Time-Scale will result in narrow widths, proportionally spread across the time range.

Category will enable you to make the width as wide as the x incriment, but it will NOT be in proportion to the time range.

I often strike a compromise, by setting up my Source Data table to include every time incriment I want to display in the chart (Week, Month, Quarter etc), but set the x-axis to Category. In that way I get proportionality on the time scale AND I can make the width of bars the width of each incriment.



Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[GlennUK]

Thanks Skip. It's been a long time since I played with axes.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

Glenn,

Axes, and it shall be given unto you! ;-)

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[GlennUK]

Axes, and it shall be given unto you!

( groan ) ( tries to think of witty reply .... )
Goalseek, and ye shall find.


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.