sherriwatkins
New Member
- Joined
- Jun 10, 2015
- Messages
- 10
I need some help! I am usually really fluent in all things Excel, but this has me stumped. I have a table with over 1350 rows of data. I am trying to create an XY scatter chart that will allow me to chart only the information that has been sorted in the table. This table has 6 sets of data for the Y and 6 sets of data for the X axis. Y is the power and X is the flow (see below). I know I can manually selecteach row to put in the chart but is there a way to have Excel do this for me since there is so much data? I need to beable to create a master scatter chart that will take my raw data and as Ifilter rows out, will automatically adjust the chart. I hope this makes sense.
<colgroup><col width="92" style="width: 69pt; mso-width-source: userset; mso-width-alt: 3364;">
<col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;">
<col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;">
<col width="37" style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;">
<col width="40" style="width: 30pt;">
<col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;">
<col width="40" style="width: 30pt;" span="13">
<tbody>
</tbody>
Thanks,
Sherri
Manufacturer | Model Number | Date | Type | Stage | Pressure | HP | Flow | Power | ||||||||||
AC | G36 | 11/20/13 | A | 1 | 102 | 50 | 240.0 | 220.0 | 150.0 | 100.0 | 50.0 | 30.0 | 21.00 | 20.00 | 19.00 | 19.00 | 25.00 | 27.00 |
AC | G37 | 1/16/14 | A | 2 | 115 | 50 | 235.0 | 220.0 | 150.0 | 100.0 | 45.0 | 35.0 | 21.00 | 21.00 | 19.00 | 19.00 | 24.00 | 25.00 |
BC | M23 | 1/16/14 | W | 1 | 125 | 50 | 225.0 | 215.0 | 150.0 | 95.0 | 35.0 | 30.0 | 22.00 | 21.00 | 20.00 | 20.00 | 26.00 | 26.00 |
BC | M24 | 7/16/14 | W | 2 | 102 | 40 | 205.0 | 185.0 | 150.0 | 95.0 | 40.0 | 30.0 | 19.00 | 18.00 | 18.00 | 17.00 | 21.00 | 22.00 |
Thanks,
Sherri