Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2013
    Posts
    171
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Changing Horizontal axis location on Chart

    I have Excel 2007 running on Windows 7 PRO (64 bit). I am having a problem with making a simple bar chart, and cannot locate the horizontal axis where I want it. I have attached the spreadsheet with the chart.

    My input data is the B column (months) and the C column (# of events). Notice that Months start in B10 (Jan) and go thru B21 (Dec). That is how I want the vertical axis on the chart to read---Jan at the top and Dec at the bottom. I also want the horizontal axis to be on the bottom of the chart.

    When I first created the chart, the horizontal (value) axis was on the bottom, but on the vertical (category) axis the months were listed with Dec at the top, and Jan at the bottom--not the order shown in column B. So I selected the vertical axis, chose Format Axis, and checked 'Categories in reverse order'. That provided what you see on the chart--the months are now as I want them, but the horizontal axis is now at the top! I cannot figure out how to move it back to the bottom of the chart. I went to Excel Help, but it did not address the situation, at least that I could find.

    Can someone provide me a little guidance on this?

    Thanks,


    Harry
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    hmw,

    Set "Horizontal axis crosses "at maximum category"

    hmw.gif

    HTH,
    Maud

  3. #3
    2 Star Lounger
    Join Date
    Jul 2013
    Posts
    171
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Maudibe:

    Thank you VERY much!

    Why does Excel place Dec. at the top of the chart Vertical axis to begin with, rather than at the bottom, as the data in Column B has it?

    Harry

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    You are welcome Harry. BY design, I am guessing it was assumed that the left lower vertex is the starting point of the graph.

    Good luck,
    Maud

  5. #5
    2 Star Lounger
    Join Date
    Jul 2013
    Posts
    171
    Thanks
    5
    Thanked 0 Times in 0 Posts
    Maudibe:

    Sounds reasonable. Thanks.


    Harry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •