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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks