+ Reply to Thread
Results 1 to 1 of 1

Help needed on getting second series on pivot tables

  1. #1
    Forum Contributor
    Join Date
    12-18-2013
    Location
    Kings Lynn, England
    MS-Off Ver
    Excel 2019
    Posts
    234

    Exclamation Help needed on getting second series on pivot tables

    Hi all,
    I am struggling to get a second series on a chart that I created from a pivot table.
    I have attached a sample spreadsheet to show.
    Simplistically, the graphs on the dashboard tab, I want to replace with graphs that I have created from the pivot table (Das pivot data is the dataset).
    I want to control these by a single slicer (and possibly a timeline slicer). However, when I try and add additional fields to the pivot data from the selection it combines everything into one.
    Can anyone help show me what is wrong?

    Thanks in advance.
    Attached Files Attached Files

+ 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. Formatting CSV data to excel for easy pivot tables - Advice needed
    By noobnoob in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-30-2020, 06:13 AM
  2. Changing Columns/Series in Pivot Tables when Filter is changed
    By mdp22 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-18-2018, 01:49 PM
  3. Changing Columns/Series in Pivot Tables when Filter is changed
    By mdp22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2018, 09:05 AM
  4. 5min interval data series to 10min using pivot tables
    By env-eng in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-11-2015, 06:33 AM
  5. Excel 2007 pivot tables counting dates help needed
    By petal522 in forum Excel General
    Replies: 1
    Last Post: 10-24-2012, 12:11 AM
  6. Replies: 2
    Last Post: 07-28-2010, 04:53 AM
  7. Help needed with pivot tables
    By danielz in forum Excel General
    Replies: 4
    Last Post: 04-05-2006, 05:22 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