+ Reply to Thread
Results 1 to 3 of 3

Creating a chart that combines identical names as one of the values

  1. #1
    Registered User
    Join Date
    05-17-2018
    Location
    Okinawa
    MS-Off Ver
    2016
    Posts
    2

    Creating a chart that combines identical names as one of the values

    Hello,

    The title might be a little hard to understand so I have attached a picture to help visualize my problem. The issue is, I am trying to combine the quarters so that there is only 4 bars(1 for each quarter) in my chart, whereas right now, it shows 9. Any help would be appreciated. Thank you.Untitled.png

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

    Re: Creating a chart that combines identical names as one of the values

    You need to summarize the data with formula or pivot table. Charts only display the information they are provided with, they don't summarize.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-17-2018
    Location
    Okinawa
    MS-Off Ver
    2016
    Posts
    2

    Re: Creating a chart that combines identical names as one of the values

    Thank you for the assistance!

+ 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. Creating a macro that combines data from several CSV files into a single datasheet
    By Chimney343 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-13-2017, 11:39 AM
  2. Replies: 2
    Last Post: 01-16-2016, 08:49 PM
  3. Excel Chart that combines a sectional bar and has a plotted point
    By JJV191 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-20-2014, 08:21 PM
  4. Chart - Scattered - identical values, but different curves
    By Bandini in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-04-2014, 09:41 AM
  5. Creating dynamic userform based on several file names and creating chart overlays
    By Thorn23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2014, 12:09 PM
  6. Help Creating a formula that combines a countif statement and a date filter
    By mark.studley in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-14-2013, 04:09 AM
  7. Creating an Special Key Column for Cells with Identical Values
    By walle786 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2013, 02:42 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