#1
|
|||
|
|||
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.
|
#2
|
||||
|
||||
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Group multiple data sets | muskhal | Mail Merge | 1 | 04-24-2022 05:29 PM |
How to make comparison chart to display two varying sets of data. | Matrix2021 | Excel Programming | 0 | 07-15-2020 07:04 PM |
Exporting multiple data sets from a single Word Form into Excel | Tom Saylor | Word VBA | 6 | 09-11-2016 05:22 AM |
Pivot Table: Show Data For Multiple Items | jhato160 | Excel | 14 | 08-01-2016 11:24 AM |
One bar chart for 3 sets of data | rclloyd | Excel | 1 | 02-03-2006 09:51 AM |