Visualize a Dataset

The following prerequisites must be met before you can query a dataset with Service Explorer:

• A valid Windows Live ID or OrgID.
  If you need a Live ID go to the Windows Live home page and sign-up for a Live ID.
  
  
• A valid Windows Azure Marketplace account.
  If you do not have a Windows Azure Marketplace account, go to the topic Create Your Account and follow the instructions there.
  
  
• A subscription to a dataset of interest.
  If you have not subscribed to a dataset, go to the topic Subscribe to a Data Offer and follow the instructions there.
  
  
• A query result set from your dataset of interest.
  If you do not have a result set from a query, go to the topic Query a Dataset and follow the instructions there.
  
  

After you query the dataset you can elect to visualize the result set as a column chart (vertical), bar chart (horizontal), or a line chart.

1. Click the Visualize tab. (Figure 1 #1)
   
   
2. Give your chart a title (Figure 1 #2).
   
   
3. From the dropdown, select a type of chart. (Figure 1 #3)
   See the following Chart Examples for example charts.
   
   
4. Type in your X-axis label. (Figure 1 #4)
   
   
5. From the dropdown, select your X-axis values. (Figure 1 #5)
   
   
6. Type in your Y-axis label. (Figure 1 #6)
   
   
7. From the Y-axis value list, check each value that you want to chart. (Figure 1 #7)
   
   
8. Check Show Scale Break if you want the Y-axis to break.
   Scale Break allows you to view Y values that go over a large range in a more readable way. (Figure 1 #8)
   
   
9. Select a color pallet. (Figure 1 #9)
   
   
10. Click Create. (Figure 1 #10)
    
    

Figure 1 – Visualize a Query Result

The following example charts are from the preceeding query.

Bar Chart

Figure 2 – Bar Chart Example

Column Chart

Figure 3 – Column Chart Example

Line Chart

Figure 4 – Line Chart Example

Tasks