x

SSRS Bar chart and a line indicator

Hi,

I used a bar chart to show 3 values Budget , actual and forecast. For the third value Forecast instead of bar I need a line indicator to show the value on the same bar chart.

is it possible to use a indicator for only one value on the same bar chart?

Thanks Lakshmi
more ▼

asked Apr 20, 2012 at 11:24 PM in Default

Lakshmi_sqlbi gravatar image

Lakshmi_sqlbi
21 8 8 10

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
I think so yes, you can add a second series of type line on to the graph and set it up that way. I've not tested this so you may run into some issues with the axis etc as some types of series do not play nicely together
more ▼

answered Apr 23, 2012 at 11:36 AM

Dave Morrison gravatar image

Dave Morrison
472 2 3 4

think the second (or indeed both) series will need some expressions to keep the axis scales the same. In theory though it should work.

Apr 23, 2012 at 12:35 PM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x113

asked: Apr 20, 2012 at 11:24 PM

Seen: 1371 times

Last Updated: May 09 at 02:33 AM