The chart we will be creating in this example uses fictional data to show customer satisfaction for a product based on various age ranges. They are created by a line chart which has been set to have no color. The data labels in the chart above are also an illusion. This provides us with the ability to create the illusion of columns. It is even possible to plot points in the same place along the x-axis, which results in a vertical line. By changing the x-axis to display a data axis we can plot a point anywhere along the x-axis. Normally, this chart type uses fixed intervals for the x-axis (the bottom axis). To create a variable width column chart we will be using a stacked area chart. With a bit of trickery, it is possible to create this chart: However, it is possible to get creative with a stacked area chart and the correct data layout. This same principle of column width also applies to histograms.Įxcel does not have any settings to change the width of individual columns when using a column chart. For example, where each column represents different ranges of data. However, in some circumstances, it would be better for the width of each column to be different. In Excel, the standard column chart will display all columns with the same width at regular intervals.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |