Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 17th 05, 06:07 PM posted to microsoft.public.excel.charting
JDToellner
 
Posts: n/a
Default How do I graph a pivot table of sparse values?

I have created a pivot table that counts the number of occurences of numeric
values between 4 and 16.

The pivot table contains the following

Value Count
9 2
10 1
11 1
12 7
13 4
14 1
15 1
16 3

There were no records that had the values 4, 5, 6, 7 or 8.

I have created a pivot/column chart to display the counts (y-axis) of each
value (x-axis). Because there are no counts for 4, 5, 6, 7 and 8 the scale
for the x-axis is 9 to 16.

How do I create a chart with a scale from 4 to 16?

(I've also noticed that if there are only records for 4, 5, 6, 7, 9, 10, 11,
12, 13, 14, 15 and 16 that the chart x-axis will not include an 8.)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DonĀ“t show zero values in Pivot Table Lina Excel Discussion (Misc queries) 1 October 12th 05 02:47 PM
pivot table sort entries that don't yet appear in table rachael Excel Discussion (Misc queries) 11 September 19th 05 11:29 PM
Pivot Table - Multiple consolidation Range tengreen Excel Worksheet Functions 1 July 1st 05 07:18 PM
pivot table with selection values not included in the base data confused Charts and Charting in Excel 0 June 21st 05 02:42 PM
Pivot Tables, Help? Adam Excel Discussion (Misc queries) 6 March 24th 05 02:35 PM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017