+ Reply to Thread
Results 1 to 4 of 4

Displaying two sets of data in column chart with one set as a simple figure within other

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Minneapolis
    MS-Off Ver
    Excel 2007
    Posts
    6

    Displaying two sets of data in column chart with one set as a simple figure within other

    I was asked recently to produce a report that captured two sets of data and displayed them in a column chart. The caveat to this request was that only one set of data be displayed as bars and that the other set show as a figure(count) within the bar. Because that set of data was so much smaller than the other, so seperate columns would be too short to display meaningful information.

    Is there a way to do this? Attached is a visual example.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-30-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Displaying two sets of data in column chart with one set as a simple figure within oth

    Make chart with both series, then edit numerical series to show data labels and have no fill, also overlap series.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-14-2013
    Location
    Minneapolis
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Displaying two sets of data in column chart with one set as a simple figure within oth

    Perfect. Thanks!

  4. #4
    Forum Contributor
    Join Date
    07-30-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Displaying two sets of data in column chart with one set as a simple figure within oth

    If this has solved your issue, then set thread as Solved, and bump my rep with a click on the * pls

+ 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. Can't figure out how to graph 2 sets of data for each participant.
    By tr71 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-06-2013, 04:34 AM
  2. Problem Displaying Specific Data From a Simple Model
    By ask4thesea in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2011, 10:48 PM
  3. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 AM
  4. Create a graph displaying 2 sets of data
    By ravihotwok in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 05-12-2009, 11:08 AM
  5. Simple way to keep 2 sets of data represented fully in a 3rd?
    By JBeaucaire in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2008, 08:11 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