+ Reply to Thread
Results 1 to 3 of 3

How change vertical alignment of dates in horizontal axis of chart?

  1. #1
    Registered User
    Join Date
    11-09-2018
    Location
    North Hollywood, CA
    MS-Off Ver
    2016
    Posts
    2

    How change vertical alignment of dates in horizontal axis of chart?

    I created a sample worksheet to capture blood pressure readings (see attached). The chart is fine except the dates along the x-axis are displayed horizontally which causes them to get all "crunched up". How can I display the dates using a vertical alignment? (like the times)?

    TIA,
    ff
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,108

    Re: How change vertical alignment of dates in horizontal axis of chart?

    G'day and welcome to the forum,

    One option is to place the following formula in A5 then copy and drag the formula.

    Please Login or Register  to view this content.
    Then right click on the chart select 'Select Data' then edit your horizontal axis to
    Please Login or Register  to view this content.
    Then right click on the horizontally axis click on 'Format Axis' then click on 'Alignment' then in the field box select 'Horizontal' then adjust the 'Custom angle' to suit to your liking.
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Registered User
    Join Date
    11-09-2018
    Location
    North Hollywood, CA
    MS-Off Ver
    2016
    Posts
    2

    Re: How change vertical alignment of dates in horizontal axis of chart?

    ratcat,

    Your solution worked like a charm.... I didn't think about creating a single string (in column A) as you did. Worked well. Thanks. Case closed! ff

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1