![](/fileadmin/_processed_/4/d/csm_26-1_07f36e9aed.jpg)
![](/fileadmin/_processed_/a/e/csm_26-2_c459725dc6.jpg)
![©ecolotrain](/fileadmin/_processed_/d/d/csm_26-3_79e53fd6b4.jpg)
![](/fileadmin/_processed_/5/e/csm_26_4_a811219fed.jpg)
![©ecolotrain](/fileadmin/_processed_/9/2/csm_26-5_a7912321d3.jpg)
![©ecolotrain](/fileadmin/_processed_/7/b/csm_26-6_618b449208.jpg)
![©ecolotrain](/fileadmin/_processed_/c/2/csm_26-7_01e478aea5.jpg)
Find out
Excel allows you on to create charts using the data in a given worksheet. When using the Chart Wizard, you can choose from different types of charts and specify chart options. It is worth noting that some types of chart may require a re-arrangement of the data. For example, if you want to create a column, bar, line, area, surface or pie chart, your data must first be arranged simply in columns.
Or in rows:
If you want to create an XY (scatter) or bubble chart, arrange the X values in the first column and the corresponding Y values in adjacent columns.
After arranging the data in your worksheet, select the cells you want to use in the chart. To select cells that are not in a continuous range, select the first cells, press and hold down CTRL and select the additional cells. It is important that the non-adjacent selection of cells forms a rectangle.
The non-adjacent cells are treated as if they appear together.
Go to Insert|Chart or click the Chart Wizard button in the toolbar and follow the instructions in the Chart Wizard. You can create different types of charts, e.g. with figures:
... or with percentages: