Quote:
Originally Posted by tomohawk
is it possible to select all 103 rows of data but graph by the lowest 20 values in column B only
|
I hope this is how you want it; In the attached, the chart at cell K2 is a pivot chart. The raw data in columns A & B do NOT need to be in any particular order. The pivot table and chart show only the bottom 20 values from column A (see the filter in cell S2):
2025-11-23_142052.jpg
Also, I've edited your chart at cell C2 to show similar data, but this requires your sorting and the selection of just the top 20 rows of data to achieve.