Displaying two different data in a chart

[avinrosh]

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.

[v-yulgu-msft]

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

[Ashish_Mathur]

Hi,

Try a Line and Clustered column chart.