RandyHarding
New Member
- Joined
- May 8, 2007
- Messages
- 35
I am trying to create two charts from one pivot table which contains
three columns of data to be charted. The pivot table contains Date,
time of day, and three pivoted columns of data. On the first chart I
want only columns A and B plotted. On the second chart I want only
column C plotted.
When I create the chart all three columns are plotted. If I de-select
the column I don't want on the chart (column C's values) it is also
removed from the pivot table. This makes it impossible to create the
second chart with only column C on it.
I know I could create a second pivot table. Each table would only
have the columns I wanted to chart. However, this is daily data,
where the day of the month can be selected (drop down) to determine
the data to be plotted on the chart. I want the two charts to remain
in sync. That is, if the date is changed on one chart, it is changed
automatically on the other chart. This prevents the users from
misintrepreting the data that is plotted because they forgot to
noticed that the day of the month was changed between the two charts.
I had hoped that by using one pivot table for both charts I could
ensure that the data being displayed on each chart would be for the
same day.
three columns of data to be charted. The pivot table contains Date,
time of day, and three pivoted columns of data. On the first chart I
want only columns A and B plotted. On the second chart I want only
column C plotted.
When I create the chart all three columns are plotted. If I de-select
the column I don't want on the chart (column C's values) it is also
removed from the pivot table. This makes it impossible to create the
second chart with only column C on it.
I know I could create a second pivot table. Each table would only
have the columns I wanted to chart. However, this is daily data,
where the day of the month can be selected (drop down) to determine
the data to be plotted on the chart. I want the two charts to remain
in sync. That is, if the date is changed on one chart, it is changed
automatically on the other chart. This prevents the users from
misintrepreting the data that is plotted because they forgot to
noticed that the day of the month was changed between the two charts.
I had hoped that by using one pivot table for both charts I could
ensure that the data being displayed on each chart would be for the
same day.