Problems with chart

[sveinhelge.urdal]

I have a spreadsheet where I like to put in astacked bar.
The chart shows Completed and Outstanding cases.
I want it to show the number of completed to the left and Outstanding to the right.
In that way the bar will grow to the right as the tasks will be complete.

I have attached a sample file.

When I insert the chart it starts with Outstandings first from left.


When I change that the bar looks wrong.

The outstanding looks much bigger than Completed.

Anyone that has a solution?

 

[ETAF]

have a look at the x axis - it maybe starting at 210 , instead of zero

 

[sveinhelge.urdal]

Yes I seee that now. But I cant find a way to change it to start on zero.

 

[ETAF]

I'm also on the Mac OSX version of excel

trying to find in format - how to format the X-Axis

i went to
Chart Design
Add element
Axis - more axis options and the range appeared
right click on the axis
Format axis
Axis options appear
and i can change the Minimum to 0

the back to
Add element
Axis - unchecked the primary axis

 

[sveinhelge.urdal]

Solved.

I found the solution myself.

 

[ETAF]

glad its all resolved