Bubbles on string chart

Overview How to create Bubbles on string chart? Example Overview Bubble chart can be also modified for specific use, for example when you want to compare series showing values as weights. How to create Bubbles on string chart? Add series on a List. Perform calculations and/or analyses. Add Formula analysis with values from 1 to … Continue reading “Bubbles on string chart”

Quadrant chart

Overview How to create a Quadrant chart? Setting background colors Examples Overview Shaded Quadrant chart is helpful when you want to show in an instance positions or proportions of points in each arbitrary fixed quadrant. How to create a Quadrant chart? Add series and perform needed analyses. Add Scatter chart or Category scatter chart. On … Continue reading “Quadrant chart”

Fan chart

Overview How to create a Fan chart? Examples Overview Using Forecast analysis on multiple same series you can create a Fan chart from Time chart and show uncertainty associated with forecasts. How to create a Fan chart? Add same series on Series list – as many times as you have predicted variants – plus one … Continue reading “Fan chart”

Dumbbell chart

Overview How to create a Dumbbell chart? Adjusting chart elements Background graphic elements Examples Overview There is no dedicated chart type for Dumbbell charts. However, with Scalar/Cross sampling analyses  you can create it out of Bar chart. How to create a Dumbbell chart? Use Scalar (or Cross sampling) with ‘Calculations: Value at’ for two points in time. Add … Continue reading “Dumbbell chart”

Slope chart

Overview How to create a Slope chart? Cleaning graphical elements Adding value labels on chart Example Overview There is no dedicated chart type for Slope charts. However, with Scalar/Cross sampling analyses you can create slopes out of Category chart. How to create a Slope chart? Use Scalar (or Cross sampling) with ‘Calculations: Value at’ for … Continue reading “Slope chart”

Pie chart

Overview Settings Changing default settings Chart properties Start angle Radius Offset Units Slice defaults Slice properties Label properties Inside Outside Main title properties / Legend properties Graph layout Style sheets What analyses work with this chart type? Examples Overview The Pie chart lets you display category series. It can be added only after analyses which … Continue reading “Pie chart”

Lollipop chart from bar chart

Overview How to create a lollipop chart? Example Overview You can create lollipop chart by modifying Bar chart. How to create a lollipop chart? Open Graph layout (Ctrl+L). Under ‘Bar’ leave one series. In the left panel select that series and from above choose ‘Marker’. Close Graph layout. Click on one of the bars and … Continue reading “Lollipop chart from bar chart”