+ Reply to Thread
Results 1 to 3 of 3

Formatting Sheets for Multiple Pivot Tables and Charts

  1. 07-13-2016, 10:55 AM #1
    adrenom
    adrenom is offline
    Registered User
    Join Date
    06-17-2016
    Location
    Seattle,WA
    MS-Off Ver
    2013
    Posts
    68

    Formatting Sheets for Multiple Pivot Tables and Charts

    So I'm working with a big data set, around 50k lines and I'm using pivot charts to visually display our data.

    However I am running into issues with overlapping pivot tables so I'm trying to find the best way to format my tables so they won't run into any overlap issues.

    To begin with, I am not 100% sure how many rows/columns I need as the list gets pretty expansive when certain slicer filters are selected so I can't format them correctly that way.

    Any ideas on good ways to handle formatting pivot tables so that when they expand they don't overlap? I'll have probably around 15-30 pivot charts/tables.

    Is it a good idea to put the big ones on separate sheets then hide them?
    Reply With QuoteRegister To Reply
  2. 07-13-2016, 11:06 AM #2
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Formatting Sheets for Multiple Pivot Tables and Charts

    Hi,

    If you don't know ahead of time what the maximum size might be, I would suggest putting each pivot table onto its own sheet.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  3. 07-13-2016, 11:08 AM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formatting Sheets for Multiple Pivot Tables and Charts

    Hi,

    Unless there's any reason not to I'd put them all on sheets of their own. For ease of reference you could create a contents page, and although you can't create a normal hyperlink to the chart sheet a simple macro would give you the equivalent of a hyperlink
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Single drop down list to change multiple pivot tables/charts.
    By ZeDoctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-04-2013, 11:31 AM
  2. Pivot Tables - need to do separate pivot tables for multiple sheets in same format
    By tconnell1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2013, 07:04 AM
  3. Pivot Tables that updates multiple pie charts at once
    By Paragoomba in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-08-2013, 02:40 PM
  4. Exporting multiple Pivot Tables and Charts in Excel 2007
    By deltaquattro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2011, 04:05 AM
  5. Common filter for multiple pivot tables in different sheets
    By johnnyp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2011, 01:05 AM
  6. vba - formatting multiple pivot charts?
    By kuraitori in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-16-2010, 04:51 AM
  7. customised printing of multiple pivot charts & tables - unsure how to progress
    By Tim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2005, 09:05 AM
  8. Using Pivot Tables And Charts To Create Dynamic SPC Charts
    By mattnhs in forum Excel General
    Replies: 0
    Last Post: 01-19-2005, 06:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1