A Bar Chart, within a bar chart

[Cooperdam]

I have written a report in Reporting Services that shows the expenses as a variant amount against the Budget_amount, by product category. This variance amount is shown as a bar chart.

Now they ask, can I show at the bar, instead, the budget_Amount (in our co. every product cat. is given a monthly budget_amount per customer), show this budget amount on the report, and then, show the variance, that is, what they spent over or under, sort of shaded inside the budget_amount. So if the budget_amount is $500, and they spent $600, show 500 on the bar and 100 in red within this 500.

I need to check how to do it, a bar inside another bar
I dont think reporting services allows it.

Can this be done in SSRS 2008?

 

[RiverGuy]

I don't think you can do that, but I could be wrong. Why not just stack the Budget and Actual amounts on top of or next to each other? So you'd get a blue bar and red bar next to each other.

 

[Cooperdam]

Thank you RG, just wondering, in what tool this could be done/ In Crystal Reports?

 

[Cooperdam]

RG, Do u mean use the Primary and then SECONDARY bar chart?

 

[RiverGuy]

I was just meaning to have two values on the chart.

 

[xlbo]

As per RG, use the stacked bar chart

In your example, value 1 would be

=Cost-Budget ($100)

value 2 would be

=Budget - (Cost-Budget ) ($400)

stack the 400 on top of the 100 and you have your chart

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question