Results 1 to 3 of 3

How to create a month and Year-to-date column side by side in pivot table

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    80

    How to create a month and Year-to-date column side by side in pivot table

    Dear Pivot Experts,

    I would like to create a pivot chart for monthly sales and year-to-date (cumulative) sales in one chart. I can't figure out how to get the pivot table. (see the outcome I want to achieve in the attached file).

    Hope you could guide me through.

    Thank you very much.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot Table: Move Metrics by Years Side-by-Side
    By seethesun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2016, 12:40 PM
  2. VBA to copy data from multiple sheets side-by-side into one sheet matching date
    By MHCapcog in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-02-2013, 06:11 PM
  3. [SOLVED] Excel 2007 Pivot Table side by side row labels
    By arasan25 in forum Excel General
    Replies: 5
    Last Post: 03-13-2013, 05:21 PM
  4. Graphing-Two stacked columns side-by-side per year
    By brwneyeirishlady in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-30-2006, 03:25 PM
  5. Replies: 1
    Last Post: 03-20-2006, 10:15 PM
  6. [SOLVED] How do I create stacked columns in xcel rather than side-by-side
    By Gin from Boeing in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-21-2005, 12:06 PM
  7. Data markers in a stacked chart will not sit side by side by month
    By WCH CHART PERSON in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-28-2005, 12:06 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