+ Reply to Thread
Results 1 to 7 of 7

colourful bars side by side two years compare

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    colourful bars side by side two years compare

    This is one of the great new charts of 2013

    Is there a way to get the bar colour month by month compare meaning jan 2013 and jan 2014 side by side,
    without manually coloring each bar

    This graph is fine but year at a glance see , I want to closely see jan and jan , feb and feb bar following each
    other
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: colourful bars side by side two years compare

    Though I can still see month by month in this but my eyes have to glance right and left

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

    Re: colourful bars side by side two years compare

    If you want to see months beside each other then use the switch row/column on the design tab.
    You don't need a different colour for each month, only each year.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: colourful bars side by side two years compare

    Yes Andy Pope , seems I have to changes the colours manually , I was revealed the colours of the chart

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: colourful bars side by side two years compare

    But I was able to find a revealing colour blue and red against black background

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: colourful bars side by side two years compare

    Andy Pope thanks

  7. #7
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,616

    Re: colourful bars side by side two years compare

    I landed into using this design , quite satisfied
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 07-23-2014, 11:53 PM
  2. How to make side by side floating bars?
    By S K ROY in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-14-2011, 05:53 AM
  3. [SOLVED] Separate Windows, Compare Side by Side, Vertical Split or whatever
    By Cagdas Ozgenc in forum Excel General
    Replies: 0
    Last Post: 04-17-2006, 04:00 AM
  4. [SOLVED] Compare Side by Side with 3 simulatanous sheets scrolling
    By John Louis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-11-2005, 08:05 AM
  5. [SOLVED] Compare side by side - Synchronous Scrolling in Excel 2002?
    By Cin in forum Excel General
    Replies: 1
    Last Post: 05-07-2005, 02:07 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