+ Reply to Thread
Results 1 to 2 of 2

Single Bar Graph Pivot Chart with self adjusting lines of other data for a slicer

  1. #1
    Registered User
    Join Date
    06-04-2021
    Location
    New Jersey
    MS-Off Ver
    2016
    Posts
    1

    Smile Single Bar Graph Pivot Chart with self adjusting lines of other data for a slicer

    Hi All,

    I am new to the forums here and just started my first week of work in the corporate world. My supervisor is asking me to created a dashboard in excel for some data. One of the things he wants complete is a bar graph with single bars. Also each date that corresponds to the bar also has 2 other values that correspond with it. How do I create a pivot chart with the bar, a solid line, and a dashed line representing the 3 data values for the date. This way when I create a slicer for a dashboard, the bar, line, and dashed line will all change values visually. Thank you for anyone who helps in advance, it is greatly appreciated!

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Single Bar Graph Pivot Chart with self adjusting lines of other data for a slicer

    Hello GoldsealActuary and Welcome to Excel Forum.
    I am guessing that you want something similar to the attached, if not please utilize the instructions in the banner at the top of the page.
    The source data is in columns A:C with the column headers being Date, Attribute and Value respectively.
    The pivot table has Date in the Rows area, Attribute in the Columns area and Value in the Values area.
    There is a slicer for Date.
    The pivot chart is a combo chart, designed to match my understanding of the description in post #1, which started as a clustered column chart and then changed the chart types of attributes 2 and 3.
    For future reference you will usually get more and faster responses if you include an Excel file with the initial post in the thread.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 1
    Last Post: 06-12-2019, 03:48 PM
  2. Pivot Table & Chart not responding consistently with Data Slicer
    By mjacobse in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-04-2019, 03:28 PM
  3. 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
  4. how many pivot table can be connected to a single slicer?
    By vishnu01445 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-28-2016, 05:35 AM
  5. Adjusting Pivot Table to Generate grpah then copy and paste graph into PowerPoint
    By flutergirl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2014, 11:36 PM
  6. graph not displayed using slicer in pivot
    By abraham30 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-29-2014, 01:43 PM
  7. Replies: 1
    Last Post: 02-07-2013, 07:14 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