Page History
...
Info |
---|
Download and connect to the sample data source. We are making this chart using 1 dimension and 1 measure. |
1. Execute a select * from bistudio_example within the query analyzer on the bistudio_example.xlsx file
...
5. Select [Area] in the Chart Properties drop-down.
6. Right-click on ShipDate in the Columns deck and choose [Quarter (Q3 2005)] date date grouping from the bottom half of the date options to ensure it's displayed as Continuous Data.
Stacked Area Chart
...
3. Drag ShipDate from Dimensions to the Columns deck. Right-click it and select [Quarter (Q3 2005)] date date grouping from the lower half of the date options.
4. Drag Freight, then Profit, and finally Total Due from Measures to the Rows deck.
...
7. Select [Stacked] from Chart Properties Axes Display Type.
Unstacked Area Chart
...
6. Drag ShipDate from Dimensions to the Columns deck. Right-click it and select [Quarter (Q3 2005)] date date grouping from the lower half of the date options then click Discrete to ensure it displays as Discrete Data.
Info |
---|
The order in which measures are placed in the deck determines how the layers appear in an Unstacked Area Chart. Measures to the left will appear on top of layers to the right. Layers become translucent when they completely conceal layers for other measures underneath them. |
For more on how to modify charts, such as showing Independent Axes and Dual Axes, see Chart Properties Axes.
Info |
---|
Charts can quickly be swapped from Vertical to Horizontal and vice versa by selecting [Analysis > Swap Rows and Columns] or clicking its button in the Toolbar. |
...
When Visualization builds an Area Chart, the data labels are not displayed by default on the chart.
To show labels on the chart
- Click (Show Data Labels) on the Visual Analytics tool bartoolbar. The measure values appear on the chart view.
To format data labels
- Open Label Deck.
- In the Data Label Color area, change the foreground color to red and keep the background to Automatic.
Other Actions
Other actions that you can perform on a plotted area chart are as follows:
- You can customize the foreground and background color for all labels. For more information, see Label Appearance.
- You can sort data by using various sort options available in the chart view or the Advanced dialog. For more information, see Sorting.
- You can use highlight actions to focus on the selected area. Visual Analytics makes the highlighted data points in the selected area and its data labels prominent while dimming others in the view. For more information, see Highlight Actions.
- You can filter records directly from the chart view without manually adding any fields to the Filters Deck. For more information, see Filters.
- You can export worksheets containing visualization to Image, HTML, and PDF formats. For more information, see Export Visualizations.