i need to buil a chart that it is easy to build in excel, but I don't know how to handle it using a chart in the report designer of the report component.
The chart that i have to build is the one in the attached picture. It is a waterfall chart in which you can see the delta between actual and budget distributed on the different line of business (for example delta between actual vehicles and budget vehicles is 31.5, delta between actual rail control and budget rail control is 13.3... and so on). On the other hand though the two bars representing actual and budget have the percentage distribution of the line of business (for example for the budget you can see that the total is 439.3 of which 57% is for vehicles line of business, 37% is Rail Control... and so on). Is there anyway the chance to build a chart like this one using the report component?
thank you in advance.