If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta.
While in an Excel Pivot table created in Access, I somehow became "stuck" in
a bar chart view. I'd like to view my data in "Pivot Table Form" not as a chart. Is there a toggle button or some other way to get back to a Pivot tble form? Thanks |
#2
|
|||
|
|||
If it's an embedded Excel file, there should be sheet tabs along the
bottom of the window. You probably had a cell selected in the PivotTable, then clicked the Chart Wizard button, and it inserted a new sheet for the PivotChart. Click on the other sheet tabs, and you should find the pivot table. Jersey Girl wrote: While in an Excel Pivot table created in Access, I somehow became "stuck" in a bar chart view. I'd like to view my data in "Pivot Table Form" not as a chart. Is there a toggle button or some other way to get back to a Pivot tble form? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I made a pivot table form and would like to be able to print it. | MarvTrade | Using Forms | 0 | March 9th, 2005 08:21 PM |
Pivot table/ Pivot chart view | TRS_JC | General Discussion | 0 | February 2nd, 2005 09:47 PM |
How do you view an Access table in a form | BoltonLad | Using Forms | 1 | November 16th, 2004 07:47 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Pivot Chart | Ailing | Worksheet Functions | 1 | January 15th, 2004 12:18 PM |