Reply
Highlighted
Frequent Visitor
Posts: 8
Registered: ‎06-14-2018

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.
Super User
Posts: 3,711
Registered: ‎01-14-2017

Re: Displaying two different data in a chart

Hi,

 

Try a Line and Clustered column chart.

Community Support Team
Posts: 5,392
Registered: ‎09-21-2016

Re: Displaying two different data in a chart

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