+ Reply to Thread
Results 1 to 7 of 7

Bar graph and scatter graph issue (all in one)

  1. #1
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Bar graph and scatter graph issue (all in one)

    Hi there

    I am having some issues integrating bar graph with scatter graph.

    Basically I have a list of individuals with their sales numbers. I tried to show an average line on the graph, which worked out fine.

    That said, I want to now show on the same graph, person I select from cell F5 to appear in a different bar graph color. However, I cant seem to change the "graph type" back to a bar graph from scatter graph w/o it distorting the graph? Basically, anytime I have the selected individual, I want it to appear in a different color.

    I have attached my sample workbook with how I would like the graph to show the "selected person" in a different bar graph color.

    can someone pls help? thanks.
    Attached Files Attached Files
    Last edited by jw01; 05-09-2017 at 04:46 PM.

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

    Re: Bar graph and scatter graph issue (all in one)

    You'd need to restructure your data a bit.

    Basically, 1 series for Selected (with everything else being 0) and another series which has all but selected (selected = 0).

    Then, you'd format Selected series with the color of your choice.

    See link for more detail.
    http://www.k2e.com/tech-update/tips/...nal-formatting

  3. #3
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Re: Bar graph and scatter graph issue (all in one)

    Quote Originally Posted by CK76 View Post
    You'd need to restructure your data a bit.

    Basically, 1 series for Selected (with everything else being 0) and another series which has all but selected (selected = 0).

    Then, you'd format Selected series with the color of your choice.

    See link for more detail.
    http://www.k2e.com/tech-update/tips/...nal-formatting
    I cant seem to figure out why b/c I have done this before and it's worked fine. Just cant seem to add another "bar graph" to the graph w/o it distorting the info.

    Any idea what I can do?

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

    Re: Bar graph and scatter graph issue (all in one)

    I suspect it's due to having 3rd series for Average.

    See attached for another method for adding Average line using Trend line instead of Error bar.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    11-26-2010
    Location
    usa
    MS-Off Ver
    Office 365
    Posts
    1,224

    Re: Bar graph and scatter graph issue (all in one)

    Quote Originally Posted by CK76 View Post
    I suspect it's due to having 3rd series for Average.

    See attached for another method for adding Average line using Trend line instead of Error bar.
    that was a work around my system...thanks, it did the trick

    appreciate the prompt response!!!

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

    Re: Bar graph and scatter graph issue (all in one)

    You are welcome and thanks for the rep

  7. #7
    Registered User
    Join Date
    05-16-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    1

    Re: Bar graph and scatter graph issue (all in one)

    Hi,


    I need to show the below info in a graph help me in creating one.


    id Assigned datetime IST Resolved datetime IST
    123 5/7/2017 5:04 5/7/2017 5:05
    456 5/7/2017 5:08 5/8/2017 4:21
    789 5/7/2017 6:05 5/8/2017 23:32
    321 5/9/2017 15:46 5/10/2017 5:03
    654 5/8/2017 12:17 5/8/2017 15:04
    987 5/8/2017 12:16 5/8/2017 13:54

    i want the x axis to be the Date and time info and count of id's assigned and resolved in the Y axis.

+ 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. Scatter graph labels issue
    By Number_8 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-13-2014, 06:19 AM
  2. Replies: 0
    Last Post: 09-15-2014, 02:01 AM
  3. Combining Stacked Bar Graph with Scatter Graph
    By cunningj in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-08-2014, 04:29 AM
  4. Scatter Graph to show data along side scatter points
    By jonathan.haynes in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-15-2013, 08:59 AM
  5. Scatter Graph X Asis Issue
    By AnneH in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-12-2012, 04:04 AM
  6. Issue with X axis values NOT graphing on Scatter graph and issue with Labels
    By lmausolf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2012, 07:20 AM
  7. Replies: 0
    Last Post: 06-15-2012, 03:23 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