• 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?


  • Example.xlsx
    13.9 KB · Views: 2
have a look at the x axis - it maybe starting at 210 , instead of zero


  • Screenshot 2022-11-16 at 10.47.56.png
    Screenshot 2022-11-16 at 10.47.56.png
    239.1 KB · Views: 5
  • Screenshot 2022-11-16 at 10.48.35.png
    Screenshot 2022-11-16 at 10.48.35.png
    330.5 KB · Views: 3
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


  • Screenshot 2022-11-16 at 12.15.06.png
    Screenshot 2022-11-16 at 12.15.06.png
    910.5 KB · Views: 4
  • Screenshot 2022-11-16 at 12.13.23.jpg
    Screenshot 2022-11-16 at 12.13.23.jpg
    180.1 KB · Views: 4
Last edited: