CODEWITHSUNDEEP
sql-serverreporting-servicesreportbuilder3.0
Nick G
Nick G

Reputation: 1229

Combine Column and Line Chart Report Builder 3.0

I am looking to create a 2 column chart that has a horizontal "goal" line across it. I am really just unsure how the dataset needs to look in order to achieve this. I really don't know what the use for the Category and Series group, or if I even need them. What I have is two columns that are based on inflation, so i could use the inflation rate as the X-Axis values usually between 0 and 10 except the horizontal goal line does not relate to these inflation percentages at all, they are just a static whole number value I want to display a straight line for on top of my two columns. This is what it should look like;

enter image description here

The "Assumed Returns" are the inflation values, with the $ value on the Y-Axis and the 'BasicGoal' as the orange line. I have the columns rendering perfectly, but can not get the orange line for the BasicGoal to save my life, i have tried stripLines, but they render behind the data and don't help me at all in this case, and have also gotten individual data-points to render the value of the orange line in the label, but i can't render it straight across.

Upvotes: 1

Views: 1564

Answers (1)

Dan
Dan

Reputation: 10680

Have you tried adding the goal line as an extra column in your dataset, and then adding it to the graph as a line series?

I'm assuming your dataset looks like this, with the addition of a Goal column:

 Assumed Returns   Linear Returns   Goal
 ---------------   --------------   ---------
 0.0               45,243           40,000
 0.5               48,869           40,000

Add a new series to the chart based on the Goal column and then change it's series type to line.

Upvotes: 2

Related Questions