Combination Chart line origin

[rjhh2013]

Hi,

This is purely a visual issue. I have a chart which is monthly sales, comparing; 14-15, 15-16, Budget, and 16-17 ytd actuals (year runs Jul-Jun).

For three sets of data I have the full year (14-15, 15-16, and the Budget) these are set as bars (vertical columns).

I have set the actuals as a line to map over the three other sets as a comparison.

Here is my issue - I want the line to start at 0,0 even though the data starts in the thousands for e.g. Jul sales 20,000 is the first data input. I would like the line to begin at 0 and connect to the first data point.

The closest I have got to achieving this is to insert a new column of data at the start with all 0's and then setting the axis to be "on the tick marks" but this leaves a large blank space with no bars at the start of the chart.

The Data is cumulative and laid out like the below (0 column used to hit origin):

	0	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb
14-15	0	18000	25000	40000	50000	65000	70000	72500	74000
15-16	0	19000	26000	41000	51000	66000	71000	73500	75000
Budget	0	20000	27000	42000	52000	67000	72000	74500	76000
16-17	0	20500	27650

<tbody>
</tbody>

Is there a better way to do this - I was surprised that there isn't an option to have the line begin at the origin.

Thanks,

Rob

 

[RoryA]

You can fudge it using an XY scatter rather than line chart - see this file: https://1drv.ms/x/s!AsDYl-5bgVQWgP8i3iIuW5oVLwGnwA
I've left the secondary X axis visible so you can see the settings I used for it. You can simply delete/hide it once you're comfortable with the method so that it doesn't mess up the chart display.

 

[oldbrewer]

for my edification what does the 0 point mean (it comes between jun and july after all)

 

[rjhh2013]

0 represents the start of a new financial year so Sales begin at 0

 

[rjhh2013]

You can fudge it using an XY scatter rather than line chart - see this file: https://1drv.ms/x/s!AsDYl-5bgVQWgP8i3iIuW5oVLwGnwA
I've left the secondary X axis visible so you can see the settings I used for it. You can simply delete/hide it once you're comfortable with the method so that it doesn't mess up the chart display.

Thanks RoryA - this looks a lot better