Vertical Axis Numerical Issue in a Graph/Chart

[Sundance_Kid]

Hi All,

I am having a problem trying to get the vertical axis showing numbers in millions, instead it is showing 0.0 for each tick.

It could be that I am trying to show too much.

I have 3 bits of data, I have numbered them 1, 2 & 3 in the attached image.

1. Is the bar chart and I want that showing in negative millions, but as you can see in the vertical axis everything is showing as 0.0 whereas I wanted it to show maybe 0.0, -1.0, -2.0 , -3.0 due to the negative number.
2. Is the line going across towards the top of the chart, that I want showing in thousands, which it is at 8,000 across the chart, so that is fine.
3. Is the line going across towards the bottom of the chart, that i want showing in thousands too which it is, just that the thousands are so small & slightly negative it barely registers below 0 or 0.0.

So my issue, is on the axis on the left hand side (vertical axis) where it is not showing in millions as per my point number 1.

Anybody any ideas?

Thanks

 

[Sundance_Kid]

I was able to fix the issue I had the data for the millions showing as 3.0 for three million for example, when I changed it to 3,000,000 it updated the vertical axis & worked. Thanks