• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problems with chart

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?



Active Member
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


Last edited: