Results 1 to 15 of 15

Pivot table data pulled collected together need to expand

Threaded View

  1. #1
    Registered User
    Join Date
    03-24-2018
    Location
    england
    MS-Off Ver
    office 365
    Posts
    20

    Pivot table data pulled collected together need to expand

    I have produced a pivot table which pulls the data and corresponding data from a main table. But i get the date only on the first row as shown in attached image 1.


    I would like it to be the same as image 2 so i can build a line chart of the data

    I have attached a cut down copy of the excel sheet. The data is recorded on sheet 1 and the chart is on sheet 3 with pivot table

    What i am trying to do is produce a line chart with the dates at the bottom and the Min Direct plotted across the chart

    hope this all makes sense
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by motorhomer; 04-10-2018 at 04:25 AM. Reason: cant think of a good title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 02-27-2017, 07:41 AM
  2. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  3. Automating Pivot table and pivot chart creation if data table names unknown
    By Vegiepie2016 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2016, 11:52 AM
  4. Replies: 2
    Last Post: 09-04-2015, 02:47 AM
  5. Replies: 1
    Last Post: 07-29-2015, 05:19 PM
  6. Replies: 1
    Last Post: 07-29-2015, 05:15 PM
  7. Collapse/Expand - Pivot table Fields - Need equivalent option in Excel VBA Pivot table
    By ragavendraph in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 03:00 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