Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table chart
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create chart from Pivot table but not Pivot chart? | Charts and Charting in Excel | |||
When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Pivot Table Chart - With Pivot Table Totals | Charts and Charting in Excel |