Don't do sum in pivot chart

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

docskidz

Thread Starter
Joined
Feb 3, 2013
Messages
5
I do NOT want pivot chart to SUM values. Here's the scenarios. My db has a table of Lab values (for patients). Say a patient has a Na (sodium) level drawn at 8am and is 145. At noon on the same day he has a repeat Na drawn which is 150. I do not want the total (295) shown on the Pivot Chart. Instead I want both lab results independently shown (1 at 145 and 1 at 150). I'm confident this can be done, I just can't find the answer. The rest of my chart (tables, query, filter, etc) works great.
Dan
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
Hi, welcome to the forum.
You must always keep in mind that you should at all times mention the version of Excel you're using.
About your pivot table, instead of showing the Lab Values you could show the time and not the level drawn. In that way you'll have the table showing the different times with the level drawn isntead of cumulating the Levels drawn
 

docskidz

Thread Starter
Joined
Feb 3, 2013
Messages
5
Sorry, I'm using Access 2010. Thanks for your reply. I've previously tried your suggestion about using "Time". In the table I concatenate the date & " " & time. It works OK but the problem is then every Na bar (eg 2/1/13 9:00AM, 2/1/13 10:AM etc) has a different color. This would be acceptable except when the chart also has other labs included, say for example K. I would like all the Na's to be one color and all the K's to be another. Maybe I'm asking for too much and maybe it's better to just limit the chart to one lab (K or Na or whatever). At any rate, I thank you very much for your reply.
BTW, the Lab Name is on the X axis and the Value is on the Y axis. Make sense?
 

docskidz

Thread Starter
Joined
Feb 3, 2013
Messages
5
OK, thanks to your suggestion, I have my Pivot Chart working great, EXCEPT for 1 last issue. I am using popup modal forms for my menus. On the Labs Menu I have a command button that invokes the query/pivot chart. When clicked, the Pivot Chart displays properly but behind the Labs Form. I have to close that form to be able to interact with the chart. Is there any way to make the chart a popup in front of the Labs Form? I've tried putting the Chart in it's own form, but not successfully. Maybe that is the route to go but I can't seem to make it work right. Thanks for your help.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top