+ Reply to Thread
Results 1 to 3 of 3

Improve grouped bar chart Aesthetics

  1. #1
    Registered User
    Join Date
    03-12-2020
    Location
    MD
    MS-Off Ver
    64 bit
    Posts
    4

    Improve grouped bar chart Aesthetics

    I am trying to plot grouped bar chart for the data in the attached sheet. I'm reporting on responses to an assessment. While using a grouped bar chart, some of the groups are 0 so it leaves a blank space for that group which does not make the chart look very nice (see "other/volunteer" group in option 1). Additionally when I used a stacked bar chart, again due to the small proportion of some of the groups (even smaller than the ones in this sheet) it makes it difficult to add a label, as the label is bigger than the space allocated to that group on the chart ( see 3% on on option 2). I was wondering if anyone had suggestions on how to improve any of these charts, or suggestions for other charts that will visualize the data better. Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Improve grouped bar chart Aesthetics

    I'd say option 1 looks the way it should. The series should be plotted in the same locations for each category. For option 2, I don't see the need for the data labels really; you definitely don't need both those and the gridlines and axis labels every 10%.
    Rory

  3. #3
    Registered User
    Join Date
    03-12-2020
    Location
    MD
    MS-Off Ver
    64 bit
    Posts
    4

    Re: Improve grouped bar chart Aesthetics

    Thank you. Yeah I will remove the gridlines.

+ 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. Shrink and improve ActiveSheet Chart Objects code
    By Dragondude in forum Excel Programming / VBA / Macros
    Replies: 37
    Last Post: 02-11-2019, 08:54 PM
  2. Replies: 2
    Last Post: 06-30-2017, 08:57 AM
  3. Pivot Chart Custom Labels - Improve my Macro
    By MikeRoot in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-13-2015, 05:59 PM
  4. [SOLVED] Change chart attribute when chart is grouped
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2012, 02:10 AM
  5. Formatting chart data to improve readability
    By hockey99 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-27-2011, 04:21 AM
  6. Improve quality of exported chart
    By bhofsetz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-28-2008, 06:39 AM
  7. visual aesthetics
    By philcud in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-28-2005, 07:05 AM

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