Insert Special Charts
With this function you will be able to access to the graphics gallery which are not native from Excel.
 
- Bubble in Axis

- Dot Plot

- Tornado Chart

- Dot

- Waterfall Chart

- Box Plot
 - Marimekko Chart

- Cascade

- Lines(max-min)

- Lines(high, average, low)

- Lines(max, high, average, low, min)

- Multiple progress indicator
 
A Dialog box will be displayed:
 
Insert Specials charts
 
Choose the range where the data is located:
 
Select where to insert the chart:
 
In order to create a graphic press the button Finish.
 
When creating this type of graphic, a hidden sheet will be created with the corresponding data.
This kind of graphic does not allow to display changes from the graphic data directly, it will be necessary to create a new graphic to show modifications in the data.

 

Sample:

 

In order to get a wished chart, choose a graphic.

Then select : how to insert the example > as a new sheet or new workbook.