• 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

    Hui...

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

Help with scaling a horizontal axis on a bar chart. Please see attached; not your typical axis.

Baama2

New Member
I went to a job interview and one of chart they asked me to do was a football field chart. I couldn't do it because I spent so much time doing and price volume chart. I took a pic of the data and the final of the sample chart.

Now I have done it at home but cant scale the horizontal axis like the sample. Please see attached
 

Attachments

  • Football field.xlsx
    302.3 KB · Views: 7
Right click on horizontal axis and set Axis Options -> Bounds, Minimum to -0.1

Then go to Axis Options -> Vertical axis crosses (within horizontal axis options), and select Axis value, set it to -0.1

Also, set Vertical axis Axis Options -> Horizontal axis crosses to "At maximum category".

FYI - You had Horizontal axis crossing at minimum category and vertical was expanded to entire height of the chart area (the reason why you couldn't see thick border appearing at bottom of plot area).

For the thick border, set "Line" option to solid line and choose your colour and weight.

See attached.

Question: Why is single data point for Wind coloured same as PV?
 

Attachments

  • Football field.xlsx
    303.7 KB · Views: 9
It works like magic. I did not sleep last night. I never understood that part of the axis option.

You would easily pass that test and get hired. I did not even attempt to do this chart. I was working on a second chart that I can not figure out. Please see attached. I also have this on the forum

Thanks very much
 

Attachments

  • Price Volume chart.xlsx
    53.4 KB · Views: 3
Back
Top