+ Reply to Thread
Results 1 to 3 of 3

Issue with side-by-side column graph format

  1. #1
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.85 for Mac MS 365
    Posts
    8,513

    Issue with side-by-side column graph format

    Hi all.
    I've been trying to correct this issue with this side-by-side column graph for a couple hours but w/little luck.
    The data is in date descending format though I've also put them in ascending order farther down in the spreadsheet, and w/no luck.
    Essentially, the graph as I select the data appears as it is in the first graph which is what I want EXCEPT for the x axis labels. When I point to the dates in col A for the labels the bars "shrink" and for some reason it inserts other dates not in the date list into the axis. When I select format axis and select Base Unit >> fixed >> days it gets rid of the additional dates and it "fixes" the dates in the axis BUT I end up with very thin stacked bars instead of side-by-side bar columns.

    If you look at the first graph you'll see what I want but with the dates as they appear in the second graph. Getting it corrected would be great BUT finding what I'm missing so I can correct it would be even better.
    Attached Files Attached Files
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

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

    Re: Issue with side-by-side column graph format

    Format the horizontal axis as Text rather than Date.
    Specify Interval Unit = 1 to see all axis labels
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.85 for Mac MS 365
    Posts
    8,513

    Re: Issue with side-by-side column graph format

    THAT DID IT! Thanks!

+ 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. Adding line to side by side stack graph
    By Karen311261 in forum Excel General
    Replies: 1
    Last Post: 10-05-2010, 04:04 AM
  2. Stacked AND side by side column graph...
    By Hornet_MT in forum Excel General
    Replies: 4
    Last Post: 03-01-2007, 10:23 AM
  3. Can I make a graph with side-by-side pie charts?
    By EAS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-18-2005, 10:05 PM
  4. How can i create a graph with 2 x-axis side by side?
    By Sue in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-02-2005, 03:06 PM
  5. [SOLVED] How do I show data on side by side plots within the same graph ra.
    By LAL in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-10-2005, 06:06 PM

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