+ Reply to Thread
Results 1 to 2 of 2

Displaying multiple data points for one column

  1. #1
    Registered User
    Join Date
    06-15-2015
    Location
    Seattle
    MS-Off Ver
    2013
    Posts
    62

    Displaying multiple data points for one column

    So I have a buyer associated with two data points the amount of inventory he has and the count of the SKU's but this is displayed on a weekly time base so I'm not sure how to group the data so that I can graph it. Any ideas?

    To be more clear these are two separate tables that have Buyers on the row side and weeks on the column side but data for the two sets is different. One is for $$ and the other is SKU count.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,781

    Re: Displaying multiple data points for one column

    You can have a line from each table on the same graph if the time data (weeks) is the same in both tables. You can have the $$ line associated with the primary vertical axis, and the SKU count associated with a secondary vertical axis.

    Easier to demonstrate if we had your file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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] Omit displaying data points on graph
    By avarax in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-18-2013, 06:40 AM
  2. Replies: 0
    Last Post: 08-17-2011, 11:16 AM
  3. Bar or column plot 7 dependent variables with multiple data points in each?
    By CateFranklin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-01-2011, 09:27 PM
  4. Replies: 5
    Last Post: 08-10-2009, 04:48 PM
  5. [SOLVED] Add data labels without displaying data points?
    By Brenda in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-27-2005, 12:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1