+ Reply to Thread
Results 1 to 6 of 6

Interactive Chart

  1. #1
    Banned User!
    Join Date
    03-18-2014
    Location
    Louisiana
    MS-Off Ver
    Excel 365
    Posts
    56

    Interactive Chart

    Could someone please point me in the right direction of an easy way to set up an Interactive Chart for some sales data over a period of time between vendors. Attached is the sample spreadsheet. I have Googled for it and haven't found anything that I could apply to what I need.

    TIA!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Interactive Chart

    You have not described exactly what kind of interactions you want to have with the data/chart. My first thought looking at the data was, if the data were "unpivotted" into a good database arrangement, then you could use pivot tables (and all of the tools associated with pivot tables) to interact with the data.
    Some thoughts on proper database arrangement: https://www.excelforum.com/excel-new...ml#post4906705
    Some more thoughts: https://www.excelforum.com/tips-and-...zing-data.html
    pivot tables: https://www.excel-easy.com/data-****...ot-tables.html
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Banned User!
    Join Date
    03-18-2014
    Location
    Louisiana
    MS-Off Ver
    Excel 365
    Posts
    56

    Re: Interactive Chart

    I basically would like to see trends (charts) between the sales channels over time.

  4. #4
    Banned User!
    Join Date
    03-18-2014
    Location
    Louisiana
    MS-Off Ver
    Excel 365
    Posts
    56

    Re: Interactive Chart

    Also, this data is pulled via a query in MS Access.

  5. #5
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Interactive Chart

    How about a line chart?
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  6. #6
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Interactive Chart

    I'd recommend updating your profile to accurately reflect your current Excel version. Tools/Charts available will differ depending on your Excel version.

    First, before building charts, I'd start from identifying story/data trend that you want to visualize. And model your data accordingly (I'd recommend flattening your data as MrShorty suggested).

    1. Is it to show how much each vendor contributes to overall sales over time?
    - I'd consider one of following chart type.
    Stacked Area Chart
    Combo Chart - Line and Clustered Column (I'd consider using 2nd axis for Column and base it on % of total).
    Ribbon Chart - This is useful in showing position of vendor within each period, but may not be available out of box in Excel.

    2. Is it to compare set of vendors over period?
    - Consider following
    Simple line chart
    Column Chart (Clustered)
    ?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. Interactive chart
    By Yekta in forum Excel General
    Replies: 1
    Last Post: 12-10-2014, 02:10 PM
  2. Interactive Chart
    By behrensf84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2014, 05:51 AM
  3. Interactive Chart
    By briansterling in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-04-2013, 12:44 PM
  4. Interactive chart
    By javierlazaromartin in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-02-2010, 07:53 AM
  5. interactive chart
    By arnab0711 in forum Excel General
    Replies: 2
    Last Post: 08-07-2010, 05:47 AM
  6. Interactive Chart
    By needsomehelpquickly in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-06-2008, 06:14 AM
  7. Interactive Chart?
    By squishyfrog in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-23-2006, 01:45 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