Home

Differing data sets

Highlighted
glenns8778
Occasional Visitor

I have two months of data of defects (numbers). In my chart, I am showing a line graph for one month of data, how do i show the second month of data in comparison on the same chart.

1 Reply
Highlighted

Hi @glenns8778 ,

 

It depends on how your data is organized. The simplest variant for only two months - you may generated help range with numbers from 1 to 31. Select Data for the chart, assign that range as X axis, after that add series with values for first month and second month. That is assumed you have values for each date of each month.

 

If not, to helper range with numbers you may add another couple of columns, INDEX/MATCH values into them for each month and build the graph on the top.

Related Conversations
History and Data
rosenbloomsnka in Microsoft To Do on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies