+ Reply to Thread
Results 1 to 2 of 2

How to make a dynamic line chart with multiple comparison options

  1. #1
    Registered User
    Join Date
    07-31-2019
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1

    How to make a dynamic line chart with multiple comparison options

    Hi there,

    I have a question about my dataset. I want to make a line chart of the soda sales of different brands within different stores.

    Database is as follows:

    Store: YEAR QUARTER COKE sales FANTA sales DR PEPPER sales
    1 2019 Q1 12 14 4
    1 2019 Q2 24 12 2
    1 2019 Q3 25 12 2
    1 2019 Q4 24 42 12
    2 2019 Q1 14 32 2
    2 2019 Q2 24 12 4
    2 2019 Q3 47 18 2
    2 2019 Q4 24 12 22
    3 2019 Q1 34 11 3
    3 2019 Q2 27 12 2
    3 2019 Q3 44 12 2
    3 2019 Q4 28 13 1

    So, what I would like to see in the line chart is the individual development of all the type of soda sales within each store, which is easy to do by applying the filter option in excel. however, what I also would like to know is how well store 1 does on coke in the same time periods compred to store 2 and 3. I would like to include this in just one graph. Anyone a suggestion? Thanks!

    Kind regards,

    DD

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

    Re: How to make a dynamic line chart with multiple comparison options

    Pivot Table and Pivot Chart is your friend. Along with slicer controls.

    This will allow for quick slicing and dicing of data for your analysis and visual.

    I'd recommend starting by flattening your data structure.

    Ex: Store, Year, Quarter, Sales, Drink type as header (Drink type will be attribute column holding Coke, Fanta etc).
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ 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. how to make a comparison column chart between 2 variables
    By ACrossley1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2019, 09:01 PM
  2. Replies: 9
    Last Post: 07-12-2016, 12:30 AM
  3. Line chart too wide (52 weeks) How to make it the line chart automatically?
    By sovietchild in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-26-2016, 08:20 PM
  4. Replies: 2
    Last Post: 05-02-2016, 11:31 AM
  5. Dynamic Chart Comparison Based on Drop-down Selection
    By Psionicrnd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2014, 11:25 AM
  6. Replies: 2
    Last Post: 11-14-2012, 08:59 AM
  7. Stumped on how to create a horizontal line comparison chart
    By quaffin1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-25-2009, 08:39 AM

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