It is even possible to use one of the charts from the Templates folder. You can change the default chart type to any of the chart types listed on the Insert Chart dialog box If you are creating a lot of charts, changing the default chart type can save you a lot of time. The default chart is a 2D clustered column chart using the Office theme. Make sure that your default chart is the one which you use most often. The maximum number if series does ddepend on the chart type.Īnd some chart types also require a minimum number of series, for example high-low must have 3. There are three ways you can change the chart type after the chart has been created. There is often some confusion with these two chart types.īoth these chart types can display their data in line or marker format.Īn XY Scatter chart is often used when the x-values are numeric.Ī line chart is often used when the x-values are text or dates.Įven when a line chart is used with numeric values the numbers are treated as text. It is best to choose a chart type that conveys the message in the simplest possible way. The type of chart you will use is normally determined by the type of the data although trial and error is often the best way to find the most suitable chart type. Each chart type has different attributes which can be further customised for your data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |