Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot chart not showing some data

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot chart not showing some data

Resolved · High Priority · Version 2003

Reply Wed 22 Jul 2009, 16:04Delegate Li-kim said...

Li-kim has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Pivot chart not showing some data

I have a pivot chart that seems to be missing a value. Everytime I refresh, replot, etc. this value seems to be missing. What might I be missing or doing incorrectly?

For upcoming training course dates see: Pricing & availability

Reply Wed 22 Jul 2009, 16:08Delegate Li-kim said...

RE: pivot chart not showing some data

Actually, just ignore that question, please. I have sorted it out -- it was merely a formatting issue!

Excel articles

· Understanding XML Within Excel
· How To Share Files In Excel 2010
· How To Insert, Delete, Format, Hide, Copy And Protect Worksheets In Excel
· Reporting and Analysis with Excel
· How Sharing Your Excel Data Can Help Your Business Flourish

Please browse our web site to find out more about
excel consultants and other Microsoft training courses.

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips