+ Reply to Thread
Results 1 to 5 of 5

Aligning stacked chart to the left

  1. #1
    Registered User
    Join Date
    09-17-2021
    Location
    Switzerland
    MS-Off Ver
    365
    Posts
    9

    Aligning stacked chart to the left

    Hi, is there a way to align the points of a stacked chart to the left of each column instead of the middle ?

    Chart.jpg
    Last edited by lcrivell; 09-17-2021 at 10:46 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Aligning stacked chart to the left

    Move the area to secondary axis
    Extend the cell range for the area series to 1 more beyond column data.
    add secondary horizontal axis, set Axis position to On tick marks.


    I have added a line as well to more clearly show the left column alignment
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-17-2020
    Location
    Bangkok, Thailand
    MS-Off Ver
    365
    Posts
    17

    Re: Aligning stacked chart to the left

    Your request is possible but I wonder why.
    It is hard to interpret the chart and what will be displayed for the last month?
    Attached Images Attached Images

  4. #4
    Registered User
    Join Date
    09-17-2021
    Location
    Switzerland
    MS-Off Ver
    365
    Posts
    9
    Quote Originally Posted by Pichai_Tee View Post
    Your request is possible but I wonder why.
    It is hard to interpret the chart and what will be displayed for the last month?
    How did you achieve that ? - But agreeing with your statement about visibility.
    Last edited by lcrivell; 09-21-2021 at 01:22 AM.

  5. #5
    Registered User
    Join Date
    09-17-2021
    Location
    Switzerland
    MS-Off Ver
    365
    Posts
    9

    Re: Aligning stacked chart to the left

    Thanks Andy ! The comment of Pichai_Tee is true too, in the sense that visibility is challenging in such a case.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IFERROR: Aligning text left and right
    By abdul11yusuf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-28-2016, 01:35 AM
  2. [SOLVED] Aligning Selected Text to Top Left?
    By Ourkid123uk in forum Excel General
    Replies: 1
    Last Post: 02-09-2016, 02:49 PM
  3. Replies: 14
    Last Post: 08-01-2013, 06:34 AM
  4. [SOLVED] Aligning category Axis in a stacked column chart
    By phedax in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-01-2013, 12:59 PM
  5. Left-aligning certain cells not working??
    By WorldBuilder in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-15-2012, 11:39 AM
  6. How to left aligning text in chart (from centered)
    By PhillyT in forum Excel General
    Replies: 2
    Last Post: 01-16-2012, 09:22 AM
  7. Aligning text to the right and left on same line
    By bluerog in forum Word Formatting & General
    Replies: 3
    Last Post: 04-21-2010, 04:49 PM

Tags for this Thread

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