Results 1 to 8 of 8

show multiple dates in pivot table graph

Threaded View

interested show multiple dates in pivot... 01-12-2012, 09:13 AM
dilipandey Re: show multiple dates in... 01-14-2012, 01:40 PM
interested Re: show multiple dates in... 01-16-2012, 05:59 AM
dilipandey Re: show multiple dates in... 01-17-2012, 03:30 PM
interested Re: show multiple dates in... 01-18-2012, 08:02 AM
dilipandey Re: show multiple dates in... 01-19-2012, 12:23 AM
interested Re: show multiple dates in... 01-19-2012, 03:28 AM
dilipandey Re: show multiple dates in... 01-20-2012, 02:36 PM
  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