In: Statistics and Probability
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file
format will permanently break the chart.
How i can solve this problem on excel ??
This is trying to point out that the chart you are trying to make in excel is not possible because your version of excel is not compatible meaning that either it is older version that does not support features or you have not activated your product completely.
Also, in this condition even if you try to proceed and save your work it will not be saved and reflected as final outcome and hence, it will break the chart format you are trying to make because it does not support it at first place.
What you can do?
E.g, say it does not support Histogram, you can make column chart as an alternative and edit its outlook.
data set:
33.57 26.54 38.34 31.44 26.86 27.78 25.21 29.01 36.42 54.33 24.54 30.49 24.49 41.50 29.07 41.75 29.39 47.09 44.68 42.10 |
Then, if i try to make histogram suppose my excel does not support
Then, i will generate frequency table and will run column chart on it.
Class | Frequency |
20 - 24.99 | 2 |
25 - 29.99 | 11 |
30 - 34.99 | 6 |
35 - 39.99 | 2 |
40 - 44.99 | 5 |
45 - 49.99 | 2 |
50 - 54.99 | 1 |
This column chart from frequency table pretty much looks like histogram from table 1.
Please rate my answer and comment for doubt