+ Reply to Thread
Results 1 to 4 of 4

clustered column chart...

  1. 01-17-2023, 01:15 PM #1
    Bartonsen
    Bartonsen is offline
    Registered User
    Join Date
    06-02-2021
    Location
    Norway
    MS-Off Ver
    Office 2019
    Posts
    12

    clustered column chart...

    Hi,
    I have some data that looks like this:

    Week Ann John Susan Ann(2022) John(2022) Susan(2022)
    1 10 30 30 40 20 60
    2 30 80 20 40 50 40
    3 20 60 50 60 50 30
    4 80 75 50 80 30 30
    5 20 30 80 60 90 20

    2023.png

    I want the red lines in drawing below to be Ann(2022), John(2022) and Susan(2022).
    Is this doable?

    hub.JPG
    Last edited by Bartonsen; 01-17-2023 at 01:19 PM.
    Reply With QuoteRegister To Reply
  2. 01-17-2023, 03:04 PM #2
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: clustered column chart...

    This gets you close to what you are looking for. I created a combo chart and manually colored each column in the chart.

    Please see attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 01-17-2023, 04:39 PM #3
    Bartonsen
    Bartonsen is offline
    Registered User
    Join Date
    06-02-2021
    Location
    Norway
    MS-Off Ver
    Office 2019
    Posts
    12

    Re: clustered column chart...

    Thanks. Let me try it out tomorrow and see if it fullfill my needs...
    Reply With QuoteRegister To Reply
  4. 01-18-2023, 12:18 PM #4
    Bartonsen
    Bartonsen is offline
    Registered User
    Join Date
    06-02-2021
    Location
    Norway
    MS-Off Ver
    Office 2019
    Posts
    12

    Re: clustered column chart...

    Quote Originally Posted by 63falcondude View Post
    This gets you close to what you are looking for. I created a combo chart and manually colored each column in the chart.

    Please see attached.
    Thanks 63falcondude. I tried it out today, and it worked perfect!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Column chart (clustered column) with multiple columns and in proportion values
    By lydiat in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-14-2021, 01:29 PM
  2. Create a 4 variable combo chart with a clustered column, stacked column, and line
    By mumbojumbo10 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-29-2015, 10:58 AM
  3. Clustered Column Chart ($$ and %)
    By greentea in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-05-2014, 04:26 AM
  4. 2D clustered column chart
    By flandophile in forum Excel General
    Replies: 2
    Last Post: 09-29-2011, 10:00 PM
  5. Clustered column chart
    By TechRetard in forum Excel General
    Replies: 2
    Last Post: 01-26-2011, 06:01 PM
  6. Clustered Column Chart Help
    By LordMarcus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-19-2009, 12:23 AM
  7. clustered column chart
    By ExcelUser4 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-19-2007, 06:46 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1