+ Reply to Thread
Results 1 to 4 of 4

Can a chart have different axis names based on the slicer used?

  1. #1
    Registered User
    Join Date
    12-02-2014
    Location
    Austin, Texas
    MS-Off Ver
    2016
    Posts
    10

    Can a chart have different axis names based on the slicer used?

    The attached workbook contains a small table (4 columns, 24 rows). It's meant to show monthly unit and sales data for 6 geographic regions. Originally, a slicer was added to allow a user to update a chart to display all regions for a specific month. The chart displays the region as the x-axis, with units and sales on the y and secondary y axes. With me so far? I recently added a second slicer, that would allow the end-user update the chart to just his or her region. But, all the axes remain unchanged, and the x-axis becomes meaningless. I would prefer if the x-axis displayed date labels when that slicer is selected. Or, as a compromise, the region and date, which - honestly - might make for better results when multi-select is used. Any ideas would be greatly appreciated! TYIA
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,882

    Re: Can a chart have different axis names based on the slicer used?

    Use Pivot Table and Pivot Chart.

    Add [YYYY-MM] & [Region] as Rows (i.e. Axis - Categories).

    Then add Both NIC columns as Values (Sum of).

    Insert Pivot Chart and choose combo chart, with NIC Count as secondary axis.

    Right click on one of the buttons and remove all buttons.

    See attached.

    Edit: You can adjust axis format by using options and choosing custom number format.
    Attached Files Attached Files
    Last edited by CK76; 02-13-2020 at 02:44 PM.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    12-02-2014
    Location
    Austin, Texas
    MS-Off Ver
    2016
    Posts
    10

    Re: Can a chart have different axis names based on the slicer used?

    Thanks CK76. Worked like a charm!

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,882

    Re: Can a chart have different axis names based on the slicer used?

    You are welcome

+ 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. Changing Pivot Chart Y-Axis when different slicer is selected
    By future_career in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2016, 05:22 PM
  2. Pivot Chart Secondary Axis Issue with Slicer
    By bbr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-20-2014, 05:57 PM
  3. Replies: 1
    Last Post: 03-01-2014, 07:10 AM
  4. [SOLVED] Chart axis has numbers but data range is names
    By monika_s in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-21-2014, 07:29 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. [SOLVED] Bubble chart with names in X and Y axis instead of numbers
    By Federico in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-09-2005, 08:06 AM
  7. Chart with dynamic x-axis names
    By Jon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2005, 10:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1