Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Apr 30, 2009

Line Chart for Analysis Services Data - Page 6

By William Pearson

X Axis Tab

1.  Click the X Axis tab.

We advise our client colleagues that the labels assigned to the groups that we created earlier will suffice to address the visual x-axis, and that we therefore need only to deal with the “labels” settings (we can leave the Title and other settings at default).

2.  Ensure that the Show labels checkbox is checked.

3.  Click the Style button to the immediate right of the blank Format code box.

The Style Properties dialog box appears, once again.

4.  Make the settings, listed in Table 3 below, within the Style Properties dialog box:

Property

Setting

Family

Arial

Size

9pt

Style

Normal

Weight

Normal

Color

Black

Decoration

None


Table 3: Style Properties Dialog

The Style Properties dialog appears, with our settings, as shown in Illustration 33.


Illustration 33: Style Properties Dialog Box with Settings

5.  Click OK to accept changes and to exit the Style Properties dialog box.

We return to the X Axis tab, once again, where we will leave all else at default. The X Axis tab appears, with our settings, as depicted in Illustration 34.

Chart Properties Dialog Box – X Axis Tab with Our Settings
Illustration 34: Chart Properties Dialog Box – X Axis Tab with Our Settings

We will move to the Y Axis tab in the next subsection.

Y Axis Tab

1.  Click the Y Axis tab.

We propose doing a little more “adjustment” to the default settings in the Y Axis tab than we witnessed in its X Axis counterpart in the section above. These modifications will be primarily in the interest of presentation compactness and clarity.

2.  Type (or cut and paste) the following into the Title box on the tab:

="Total Internet "& vbcrlf &" Sales" &""

Here we are adding the title “Total Internet Sales”, using the “vbcrlf” keyword within the expression to force the word “Sales” into a second row of the title, so that the title takes up less vertical space.

3.  Click the Style button to the immediate right of the Title box.

The Style Properties dialog box appears, as we have seen in earlier sections.

4.  Make the settings, listed in Table 4 below, within the Style Properties dialog box:

Property

Setting

Family

Arial

Size

9pt

Style

Normal

Weight

Normal

Color

Black

Decoration

None


Table 4: Style Properties Dialog

The Style Properties dialog appears, with our settings, as shown in Illustration 35.

Style Properties Dialog Box with Settings
Illustration 35: Style Properties Dialog Box with Settings

5.  Click OK to accept changes and to exit the Style Properties dialog box.

We return to the Y Axis tab.

6.  Ensure that the Show labels checkbox is checked.

7.  Type the following into the Format code box:

#,###

8.  Click the Style button to the immediate right of the newly occupied Format code box.

The Style Properties dialog box appears, once again.

9.  Make the settings, listed in Table 5 below, within the Style Properties dialog box:

Property

Setting

Family

Arial

Size

9pt

Style

Normal

Weight

Normal

Color

Black

Decoration

None


Table 5: Style Properties Dialog

The Style Properties dialog appears, with our settings, as depicted in Illustration 36.

Style Properties Dialog Box with Settings
Illustration 36: Style Properties Dialog Box with Settings

10.  Click OK to accept changes and to exit the Style Properties dialog box.

We return to the Y Axis tab, once again, where we will leave all else at default. The Y Axis tab appears, with our settings, as shown in Illustration 37.

Chart Properties Dialog Box – Y Axis Tab, with Our Settings
Illustration 37: Chart Properties Dialog Box – Y Axis Tab, with Our Settings

We will move to the Legend tab next.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM


















Thanks for your registration, follow us on our social networks to keep up-to-date