Differing data sets

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

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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies