+ Reply to Thread
Results 1 to 2 of 2

Pivot Table-Bar Graph Type

  1. #1
    Registered User
    Join Date
    01-20-2009
    Location
    Scotia, New York
    MS-Off Ver
    Excel 2003
    Posts
    2

    Pivot Table-Bar Graph Type

    Unable to figure out how to get the pivot table to display and compare '08 and '09 information in side by side bars (bar graph type of pivot table). Tryed different ways of arranging the data (dates, categories, data#'s) but couldn't get the desired results. Can you help?
    Last edited by VBA Noob; 01-21-2009 at 09:41 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482
    The information in columns should be plotted as separate series.

    Does the Year information generate 2 columns in your pivot table?

    Can you post a small example file?
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

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