Results 1 to 8 of 8

show multiple dates in pivot table graph

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-20-2011
    Location
    lancashire,England
    MS-Off Ver
    Excel 2013
    Posts
    187

    show multiple dates in pivot table graph

    Hi, i want to show from the attached file a pivot chart that shows 2 entry dates on the chart.
    In column "R" a 1 is placed to signify a seperate check for that day is used, so when plotted both days results are shown.
    When i pivot the data it just puts the date together. How do i seperate so both results are shown

    In column "AP" is the data split into the dates, but if i do it this way i cant get rid of the -, blank or 2 that may be displayed, and the data looks messy.

    Any suggestions???
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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