Hi,
I have a bar chart where I have average number of claims by month. I want a goal line say at 60 which is just a horizontal line on the graph? How can I achieve this? Any ideas?
Thanks!!
hourigan (BOB member since 2007-04-06)
Hi,
I have a bar chart where I have average number of claims by month. I want a goal line say at 60 which is just a horizontal line on the graph? How can I achieve this? Any ideas?
Thanks!!
hourigan (BOB member since 2007-04-06)
In the past I have created a dummy data set with same value for all points. I think I did in Xcelsius. Do not recall if I did it in anything else.
kevlray (BOB member since 2010-06-23)
Can you please explain in detail.
Thanks!!
hourigan (BOB member since 2007-04-06)
Well I had summary information on previous weeks (six weeks). Since the number of values on the x axis were fixed (In Xcelsius). I just put the same value in six columns and used that information as a data source for my graph. Since I do not know your particular situation, I am not sure how best to set up a ‘fixed’ data source. It may be an unlinked table with just the value of 60 repeated for the number of rows you need.
kevlray (BOB member since 2010-06-23)