Forum Discussion
qjc171819
9 years agoFrequent Visitor
Comparing data between date period for scatter chart
Hi guys, Here is a bubble chat made in excel. Basically it is a comparison chart between 2 date periods(example: 2017-04-01 to 2017-05-01 and 2016-04-01 to 2016-05-01) and showing thei...
v-qiuyu-msft
9 years agoCommunity Support
Hi qjc171819,
You can try to consider transforming data and add a column to contains period data, then add this column as Details. It will display bubbles in the same color for different period. You can try add this new column as Play Axis.
Best Regards,
Qiuyun Yu
qjc171819
9 years agoFrequent Visitor
Well, i will try it. Thanks @Qiuyun