Scatter Plot Chart with Pre-Defined Value Ranges

SanTrapGamer

New Member
Joined
Nov 29, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
I have a large series of data (8546 data values) that I'm wanting to represent visually through a Scatter Plot Chart. These values all could fall within a range of 4 values (see below). I'm having an issue trying to figure out how to properly get the information to pull.

Min value: 14040
Min-Mid Value: 20157
Mid-Max Value: 26274
Max Value: 32391

Here is a sample of the data that I want shown on the chart:

25488
24603
23895
24072
23895
23936
26727
26250
24843
23760
23760
28512
24072
23936
27612
24249
23800
27104
29205
25520
29205
28512
23829
24464
24675
23936
23936
24957
29392
25311
26019
19575
24426
23625
24080
24992
23895
25344
22032
26576
27966
26550
25520
27258
29040
24112
24288
26904
32025
23800
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,223,317
Messages
6,171,419
Members
452,402
Latest member
siduslevis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top