| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I am having problems creating pivot table of data
I am having problems creating pivot table of data, January through to
December. For months where there is no data, no entry appears in the table - Can I force it to display so that the resulting graph displays an accurate trend? |
|
#2
|
|||
|
|||
|
In the pivot table, double-click the Date field button
Add a check mark to the 'Show items with no data' box Click OK wyman wrote: I am having problems creating pivot table of data, January through to December. For months where there is no data, no entry appears in the table - Can I force it to display so that the resulting graph displays an accurate trend? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
| changing proportion of chart and data table | Charts and Charting in Excel | |||
| multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
