CHANGING/CONVERTING CHART TYPE

<< Click to Display Table of Contents >>

Navigation:  Formatting Your Chart >

CHANGING/CONVERTING CHART TYPE

Previous pageReturn to chapter overviewNext page

You have the ability to change/convert one chart sub-type to any other chart sub-type within a chart type. With chart conversion you can convert any given chart X to any requested chart Y (provided they are in the same chart type).

APPLIES TO: ALL CHARTS WITHIN THE SAME CHART TYPE

 

TO CHANGE CHART TYPES

1.Click the Type button dropdown in the Edit Chart toolbar.  Or alternatively, choose Change Chart Type from the Format Chart Context Menu

2.Choose the chart to which you wish to convert. You can only change chart sub-types from within the same chart type. (For example, you can change a Waterfall chart to a Cluster Bar).  Changing between different chart types is permitted but will delete all data and give you a blank chart.

Advanced Tip: If the source chart (the chart you are converting from) contains data that is invalid (e.g. zero or negative values) on the target chart (the chart you are converting to), you will receive a message that some data is invalid and no chart will be drawn.