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!?

Originally Posted by Andy Pope

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?