Excel Chart Question
In the attached file, I cannot get the structure that I want.
The data is sorted by column B (smallest to largest) and after that is done, I sort the first 20 records by column A.
The reason I do the second sort is that I want the data in column A to be the X axis of the chart (not as a separate series in the chart).
Also, is it possible to select all 103 rows of data but graph by the lowest 20 values in column B only
|