Adrian Cassidy
New Member
I have a Table which has 55 columns and 25000 rows. The number of rows keeps growing with new data.
I have created a Pivot table which summarises chunks of the raw data for graphing. The problem is when I select different chunks they also produce different length tables so the graphs do not look clean.
How can I get the x-axis of the graph to adjust to the number of rows in the pivot table.
Attached are two screen shots of the same portion of the screen. One where all the rows are selected, and the second (after changing the name in the report filter). Now not all the rows are selected.
HELP!!
I have created a Pivot table which summarises chunks of the raw data for graphing. The problem is when I select different chunks they also produce different length tables so the graphs do not look clean.
How can I get the x-axis of the graph to adjust to the number of rows in the pivot table.
Attached are two screen shots of the same portion of the screen. One where all the rows are selected, and the second (after changing the name in the report filter). Now not all the rows are selected.
HELP!!