+ Reply to Thread
Results 1 to 4 of 4

Help with an Area chart with specific data point identified

  1. #1
    Registered User
    Join Date
    12-27-2021
    Location
    Spokane, WA
    MS-Off Ver
    365
    Posts
    2

    Post Help with an Area chart with specific data point identified

    Hi!

    I am trying to do a combo chart (area and scatter) that shows a range of data with one specific point identified. However, no matter what formatting I do, I cannot get the data point in the area chart correctly. Here is the data that I'm trying to use:

    Ind. Min = 4000
    Ind. Avg = 8300
    Ind. Max = 11000

    Employee Total = 8124

    I've also included a sample of what my chart currently looks like. Can someone please show me (or explain to me) what I am doing incorrectly and how I can fix it to show the data on the chart in the region it should be in!?
    Attached Images Attached Images

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,244

    Re: Help with an Area chart with specific data point identified

    If you have a xyscatter series you need to specify the x value, as it currently appears to be defaulting to 1.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-27-2021
    Location
    Spokane, WA
    MS-Off Ver
    365
    Posts
    2

    Re: Help with an Area chart with specific data point identified

    Quote Originally Posted by Andy Pope View Post
    If you have a xyscatter series you need to specify the x value, as it currently appears to be defaulting to 1.
    Hi Andy! Thanks for the reply - I've tried specifying the x value, but it keeps going back to 1. I'm not sure how else to input it to prevent it from reverting back. Could you please show me how to set it up so that it reads correctly?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,244

    Re: Help with an Area chart with specific data point identified

    Example attached
    Attached Files Attached Files

+ 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. Display small chart on mouseover of another chart's data point
    By OnRope in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2013, 09:07 PM
  2. Show specific point in line chart
    By gnoke in forum Excel General
    Replies: 1
    Last Post: 11-16-2011, 04:33 AM
  3. Replies: 2
    Last Post: 06-27-2011, 10:47 PM
  4. How to name a specific point in a chart?
    By Luvidiel in forum Excel General
    Replies: 6
    Last Post: 12-08-2010, 10:51 AM
  5. Is point inside the chart area or not
    By redblack in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-14-2010, 02:50 PM
  6. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 AM
  7. Finding starting point of chart plot area
    By rweatherly in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-17-2008, 10:54 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