+ Reply to Thread
Results 1 to 13 of 13

How to create charts for individual rows of data

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    07-17-2005
    Location
    Abergavenny, Wales, UK
    MS-Off Ver
    XL2003, XL2007, XL2010, XL2013, XL2016
    Posts
    608

    Re: How to create charts for individual rows of data

    Sure.
    It's just a question of what you choose to have in your Pivot Table.
    Your original post talked about seeing a single line, so I thought that was all you wanted.

    Take a look at this version where I have added an extra sheet called Store Charts.
    Here, when you select just an area you see a line for each store within that area, which can look very busy.
    But you can just select one store, then hold down Control as you select another store. As soon as you release the Control button, that store appears as well. Continue for whatever stores you want, and the average - as in the sample as posted.
    Clicking the "x on Slicers clears that selection.

    I have shown the PT below the graph, as I often like to see the numeric data as well, but you don't have to have the Pt on the sheet at all.
    Attached Files Attached Files
    --
    Regards
    Roger Govier
    Microsoft Excel MVP

+ 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] Create individual text files from multiple rows
    By cagey1953 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2017, 01:29 AM
  2. Create Charts on Individual Sheets Based on Column Values
    By tiny369 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2016, 03:44 PM
  3. Replies: 0
    Last Post: 07-10-2015, 03:43 AM
  4. How to repeat creating individual charts from multiple rows
    By central in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-12-2012, 01:55 PM
  5. Create individual tables for each row of data
    By jencinosa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 10:52 AM
  6. [SOLVED] Create charts that update automatically from data in rows
    By Brent in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-19-2006, 08:55 AM
  7. [SOLVED] How do I create individual pie charts for 99 different employees?
    By K. Biscello in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-10-2005, 05:06 PM

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