Sometimes you want custom label on x-axis. You can this with a little workaround described below. Add Vertical line Go to Chart annotations > Annotations and add vertical line anywhere on the chart. Modify the line Click on this line and: Set Position (for Time chart – date, for Category chart – #0, #1, #2 … Continue reading “Workaround – Covering labels on x-axis”
Overview How to create a Radial bar chart? Examples Overview There is no dedicated chart type but with formulas and Cross sampling you can create one with Category Scatter chart. How to create a Radial bar chart? Prepare series. Prepare position’s values – in Formula analysis use a hundred series of each of below formulas … Continue reading “Radial bar chart”
Overview How to create a Radar chart? Adding more lines Examples Overview There is no dedicated chart type but with formulas and Cross sampling you can create one with Category Scatter chart. How to create a Radar chart? Prepare series – one of the methods would be to use PercentRank(series1, series1) formulas: PercentRank() returns the … Continue reading “Radar chart/Spider 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”
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”
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”
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”
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”
Overview How to create a Fed dot plot? Examples Overview There is no dedicated chart type for this, but it’s possible to use Time chart with a bit of formulas and get a proper Fed dot plot. How to create a Fed dot plot? Set whole chart to Weekly frequency. Add on Series list: All … Continue reading “Fed dot plot / FOMC policy dot plot”
Overview How to create a Waterfall chart? Examples Overview With a little bit of arranging series you can show series as a Waterfall chart on a Category chart. How to create a Waterfall chart? On Series list add series and same amount of ‘0’ as series. Decide the order of the series on chart – … Continue reading “Waterfall chart”