Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Question about Pivot Charts

Posted on 2013-05-28
2
Medium Priority
?
244 Views
Last Modified: 2013-06-05
I have a table with postal codes and dates.
Is it possible to have a chart for each postal code? One for postal code 6003, etc?
Or do I have to create 4 pivot tables?

Thanks for your help

MassimoscreenshotPostalCode.xlsx
0
Comment
Question by:Massimo Scola
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Jerry Paladino earned 2000 total points
ID: 39202944
You will need 4 pivot tables.   Even if you moved the postal codes to a PAGE(Report Filter) field and duplicated the charts, the selected PAGE value would update all four charts the same.
0
 

Author Closing Comment

by:Massimo Scola
ID: 39224538
OK I understand, I applied this technique to my project and it works very well.
Thanks for your help.
0

Featured Post

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question