pivot chart for multiple data sets
I want to use pivot line chart to plot two sets of data (Efficiency vs Frequency). But for some reason the chart only works for one data set. Once the second set data is selected, the line became segmented rather than a continuous line. The data set and the two plots with one and two data sets are shown in the attached picture. Can anyone tell me what is wrong? Thanks.
|