+ Reply to Thread
Results 1 to 2 of 2

Slicer changes my Chart column widths

  1. #1
    Forum Contributor
    Join Date
    02-09-2011
    Location
    Perth, Australia
    MS-Off Ver
    2016
    Posts
    161

    Slicer changes my Chart column widths

    Hi,

    I have a chart with a lot of categories. When I select just a few from the Slicer I get very wide columns. It looks really silly.

    Is there a way to maintain the column width and spacing when using Slicers?

    Thanks very much

    Dave

  2. #2
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Re: Slicer changes my Chart column widths

    Have you tried Right Click, Size & Properties, set Slicer Height/Width, check the box that says "Lock Aspect Ratio"?

+ 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. Loop through slicer, while also selecting single slicer value on separate slicer
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2018, 01:41 PM
  2. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  3. Column chart with varying column widths and picture fill help
    By ldewson86 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-12-2013, 05:39 AM
  4. [SOLVED] User Form ListBox Column Widths - How to set widths for unknown number of columns
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-10-2013, 05:24 AM
  5. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM
  6. Replies: 6
    Last Post: 06-04-2010, 11:55 AM
  7. Chart column widths
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 06-01-2005, 05:05 PM

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