Forum Discussion
Chart - Automatically detect series
Hi!! Suppose you have some XY data you would like to plot in a scatter chart I have 3 data sets that are all independent as illustarated below Is it possible to create a chart that displa...
Excel cannot detect that automatically. You'd have to organize the data differently, with a separate column for each set:
Excel will then create the correct chart: