+ 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,084

    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,084

    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)

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