I need to create a chart which shows measurements of different Customer Orders on the X-axis and the Order No. on the Y-axis. The problem is that the Order Numbers are pretty much random except for having all the same basic style (e.g. 846378-3) and are to appear on the chart in the order in which they appear in the spreadsheet. So on the scale of the X-axis instead of something like 1,2,3,4 etc I need (e.g.) 743623-4, 453664-6, 527381-3 etc.
I don't have clue though how to get Excel to do that , please help me!
I don't have clue though how to get Excel to do that , please help me!