Recession bands (Fill range)

Overview Available bands Adding recession bands Creating and saving custom bands Dynamic recession bands Exporting and importing bands Edit/customize recession bands Removing recession bands Overview Fill range is a function that fills a segment of a chart with color, based on a defined range or sequence of dates. A fill range can be used to … Continue reading “Recession bands (Fill range)”

Dynamic text

Introduction Default series and observations Series data series .Data Format Formatting numbers Formatting dates and time stamps Chart data Dynamic text in Style sheet Example Introduction By using Dynamic text in charts, you can present data from time series as part of any text that you enter. For instance, you can have a textbox with … Continue reading “Dynamic text”

Axis & Scale

How to: add an alternate axis (scale) to the chart? add thousand separator to y-axis? change axis title? change chart scale? change step length? change x-axis’ labels? change the scale of y-axis when working with large numbers? set a logarithmic scale? show last year label on x-axis? show year above month on x-axis? synchronize axes … Continue reading “Axis & Scale”

Colors & Patterns

How to: change the color of a series’ graph in a chart? change the background color of a chart? set the pattern? How to change the color of a series’ graph in a chart? Click on the series’ graph and open the Presentation properties tab at the top of the window.  In the Appearance group, you … Continue reading “Colors & Patterns”

Bubble chart

Overview What this type of chart needs? Settings Size of bubble Reference value Negative values How Graph layout works? Examples For elements not mentioned here see Elements of the chart. Overview Bubble chart is graph type which displays three dimensions of data. It can be considered as variation of scatter chart where data points are … Continue reading “Bubble chart”

Stripe, Range & Fill chart

Overview Stripe Range Fill What this type of chart needs? How Graph layout works? Example For elements not mentioned here see Elements of the chart. Overview These three graph types transform series included in chart respectively into: Stripe If there’s two series included, stripe will treat it as start and end of range, and it … Continue reading “Stripe, Range & Fill chart”

Area & Stacked area chart

Overview Area Stacked area What this type of chart needs? How Graph layout works? Example For elements not mentioned here see Elements of the chart. Overview Area This type of graph is based on the line chart, with the area below the line filled in with a certain color, this also includes negative values. Range … Continue reading “Area & Stacked area chart”

Line chart

Overview What this type of chart needs? How Graph layout works? Example For elements not mentioned here see Elements of the chart. Overview Line chart is the default type of graph which is displayed in all Macrobond documents. It shows data points connected with a continuous line. It is possible to turn on Markers and … Continue reading “Line chart”

Column & Stacked column chart

Overview Column Stacked column What this type of chart needs? How Graph layout works? Example For elements not mentioned here see Elements of the chart. Overview Column and Stacked column charts display data as vertical bars. Categories are applied depending on analysis used before. In most cases output can be a time series but after … Continue reading “Column & Stacked column chart”