+ Reply to Thread
Results 1 to 4 of 4

Stacked Chart

  1. #1
    Registered User
    Join Date
    10-22-2014
    Location
    London
    MS-Off Ver
    microsoft Office 2010
    Posts
    12

    Stacked Chart

    Hi,

    I am trying to create a stacked chart but I am not sure how to do it, I need it to show the total inquires received in the month and for each months results to show whether the quote for the inquiry is pending or Sent (Column R)

    Help SS.PNG

    I would ideally like something like this

    help ss 2.PNG

    Thanks in advance
    Attached Files Attached Files
    Last edited by honeyb23; 03-03-2020 at 09:49 AM. Reason: add attachment

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Stacked Chart

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    10-22-2014
    Location
    London
    MS-Off Ver
    microsoft Office 2010
    Posts
    12

    Re: Stacked Chart

    Thanks Pepe, I have now added it

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Stacked Chart

    You have what looks like a decent data base, so this looks to me like a job for a pivot table/pivot chart (https://www.excel-easy.com/data-****...ot-tables.html ).

    1) Select the database table -> Insert pivot table.
    2) Tell the pivot table to use "date received" as the row labels, "status" as the column labels, and "count of status" in the value field.
    3) Tell the pivot table to group the dates by month.
    4) Select the pivot table and insert your stacked column chart. Format as desired.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. [SOLVED] Combine stacked columns and stacked bars in a chart
    By maboho93 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-09-2018, 07:52 AM
  2. Replies: 5
    Last Post: 12-09-2015, 12:41 PM
  3. Stacked bar chart with stacked secondary axis markers - please help!
    By Boardlady in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-22-2013, 10:32 AM
  4. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  5. [SOLVED] How can I combine a stacked bar chart with stacked colum chart?
    By Sin in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 12-19-2005, 11:55 PM
  6. [SOLVED] ?make a combo chart with 1 stacked bar and 1 not stacked, + show t
    By y in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-26-2005, 02:06 PM
  7. [SOLVED] To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-2005, 10:06 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