+ Reply to Thread
Results 1 to 3 of 3

multiple chart from single table

  1. #1
    Registered User
    Join Date
    11-21-2014
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    1

    multiple chart from single table

    Hi, I have a table showing salesmen performance over the years. I want to show each sales person chart (bar chart) separately on a same sheet. Moreover the size of the charts should be same (values may differ), so that lookwise it will be uniform. I will add new rows when a new salesman joins, and add new column next year. Is there any solution through coding? Multiple chart from single table.xlsx

  2. #2
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: multiple chart from single table

    Hi Saleemin27,

    I have made bar chart using check boxes which allows you to compare the performance by multiple Salesman.

    Check sheet 2.

    Multiple chart from single table.png

    Regards,
    AM
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: multiple chart from single table

    Hi Saleemin27,

    I have made chart using drop down form control, with the selection of Salesman the chart within the same area will change.

    Regards,
    AM

+ 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. Chart multiple series from single table
    By brucemc777 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-30-2014, 03:53 PM
  2. Replies: 2
    Last Post: 04-15-2013, 08:50 AM
  3. Replies: 2
    Last Post: 03-05-2013, 03:07 PM
  4. Multiple chart type on a single chart
    By mangesh in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-19-2013, 10:25 AM
  5. Single X and Multiple Y Chart
    By karthikcv in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 08-09-2011, 02: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