O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Formatting the chart

If we take a look at the preceding chart, we're missing some things. We do not have a Chart Title and Axis Title. We're going to fix that.

There are two ways of accomplishing this. Right-clicking on Chart Title displays the context menu where you can access Title Properties. Here, we can set the title, visibility, font, action, position and others. We can also simply double-click on Chart Title to set a title. We can do the same with Axis Title.

If you also noticed, the legend, False and True, is not really intuitive. The legend is showing False and True values because our OnlineOrde rFlag field, which our series is based on, is of type BIT, either 0 or 1 (False or True).

To change the label of the legend, click on the legend ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required