pivot table chart
Hi,
Actually that not what Luke is saying, but your intrepretation will work:
You can create a new column in the raw data area with 20.5 on all the rows.
Then you can add this to the pivot table as a second calculated field.
But what Luke was suggesting is that you choose the command PivotTable,
Formulas, Calculated Field, enter a name and on the Formula line type =20.5,
OK.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"CMD" wrote:
Thanks, Luke.
I think what you are saying is add a column called "constant". do i then
have to enter the constant (=20.5) for every row in the pivot table?
Chris
"Luke M" wrote:
Add a calculated field to your PivotTable, using a constant for the formula
such as
=20.5
You can then add the field to your PivotChart.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"CMD" wrote:
Hi
I have a pivot table that I am using to make a pivot table chart. here is
what i would like to do.
Lets say that i am analyzing blood glucose levels in patients. I have 100
patients who have had their glucose measured. I am using the pivot table to
look at average glucose level and I am using different page fields to look at
different cuts of the data...so I have in their gender, age group, race, etc.
here is where the question comes...i would like to make a chart but in
addition to glucose levels for the patients, i would like the chart to show a
separate bar graph showing the normal range for glucose. so this normal
range is a CONSTANT. Regardless of how i manipulate the page fields, i want
the same constant normal range always appears to the right of the data. This
allows for the user to get a visual of how each cut of data compares to the
constant normal range.
Hopefully that makes sense. Thanks in advance.
Chris
|