Forum Discussion
avinrosh
7 years agoFrequent Visitor
Displaying two different data in a chart
Hello; I have following situation. I track opportunities from various clients. For me two things are important to capture a) Time spent to secure an opportunity ( i.e. date range when I started pursuing the opportunity and finally closed it) and b) revenue generated during its duration since the date it started and to the date it is delivered. So first data is in days or weeks and the second a number. My Y-axis will be title of the opportunities and X-axis the time line in days or weeks. And I want to have a bar chart which captures the duration and revenues in a single plot.
2 Replies
- Ashish_MathurSuper User
Hi,
Try a Line and Clustered column chart.
- v-yulgu-msftMicrosoft Employee
Hi avinrosh,
As mentioned in below link, please share sample data and illustrate your requirement with examples, including what you want and how to calculate. It would be better you can show us an image of the desired result.
How to Get Your Question Answered Quickly
Regards,
Yuliana Gu