+ Reply to Thread
Results 1 to 1 of 1

Pivot Chart auto enlarge

  1. #1
    Registered User
    Join Date
    11-20-2020
    Location
    SC, US
    MS-Off Ver
    Office 365
    Posts
    1

    Pivot Chart auto enlarge

    I have been at this for days. I have a pivot table and pivot chart with a slicer. I want to filter by date with a timeline. Everything works great with filter but when I filter a larger range the pivot table adds rows but chart does not auto resize and is a jumbled mess and unreadable.
    Ideally I would like to have chart extend matching the rows of the table dependent on the date range. I need to see per day always so monthly or quarterly is no help plus I use 13/4 week periods which excel doesn't recognize. I do want table and chart to spill into the next page down if needed so if I print a report the first half will be chart and second half will be table regardless of how many pages are needed
    So far I've tried regular combinations of pivot tables, pivot charts, reg tables, and reg charts, Dynamic Named ranges.
    I added Example Workbook to my attachments but not sure how to add it to this post.
    Any Help would be greatly appreciated.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Enlarge a Chart
    By shane1966 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-05-2015, 04:52 PM
  2. Auto update Pivot Chart
    By aikido1234 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-10-2014, 08:33 AM
  3. Enlarge and restore an embedded chart from a group of charts
    By Chartguy99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2014, 12:41 PM
  4. How do I enlarge a pie chart?
    By Weasel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-25-2008, 07:22 PM
  5. [SOLVED] how do i enlarge a pie chart by a fixed percentage?
    By ellen s. in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-17-2005, 10:10 AM
  6. How to enlarge stacked chart plot area
    By Carole O in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-02-2005, 05:05 PM
  7. How do I enlarge chart size in document?
    By WilkesConcierge in forum Excel General
    Replies: 1
    Last Post: 02-24-2005, 01:06 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1