Formatting a Gauge Chart

[ericb1]

I have a gauge, or dial chart on my report, and I've been through all the formatting options, trying to format just the background of the gauge, not the entire chart.

Am I missing something? I can't seem to find where to do this, if it's possible, which I believe it is. Any help is greatly appreciated, thanks!

 

[lbass]

Right click on the gauge so that it is selected->format selected item->fill tab.

-LB

 

[ericb1]

Thanks, that's what I was doing, but that fills in the background of the square around the dial also. I'm trying to fill in just the dial (half circle).

Like this:

http://www.apos.on.ca/BusinessIntelligence/DashboardsScorecards.shtml

(click on 'View Screenshots') to see just the dial colored, everything else is white.

Thanks again!

 

[lbass]

No, actually if you select the arc, you can format just the arc. However, I don't know of a way to format the background below the arc.

-LB

 

[lbass]

You could come close to this look by creating a pie chart for one value that is the background color you want, overlaying a text box colored white to block out the bottom half of the pie chart, and then overlaying the gauge chart that has the background set to transparent. The only problem I ran into is that the data label and the 0 and maximum values were partially blocked from view unless I lowered the textbox slightly, but then this left a colored area below the arc.

-LB

 

[ericb1]

Thanks so much. I was able to come pretty close by adding specific quality bands, then color coding them red, yellow, and green, and then just making them bigger (fatter). It's close enough to what I was looking at doing. Perhaps later on, I assume I can make a .gif image of the background I want, and then overlay the gauge on it.

I was just surprised to find that I couldn't do it more easily, it was the first time I really used the gauge chart, but I'd seen so many pictures of it in different places, I thought it would be easier.

Thanks again.