Question

In: Statistics and Probability

This chart isn't available in your version of Excel. Editing this shape or saving this workbook...

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 ??

Solutions

Expert Solution

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?

  • Either upgrade your excel version
  • Check if it is completely activated
  • Try to make an alternative chart without compromising the meaning.

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


Related Solutions

Create an excel workbook for the following questions. Answer these questions under your Solver work for...
Create an excel workbook for the following questions. Answer these questions under your Solver work for each respective problem. 1. Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the...
Please show all your work in Excel, please send me the spreadsheet / workbook. What is...
Please show all your work in Excel, please send me the spreadsheet / workbook. What is the market value of the following bond? Coupon 8% Maturity date 2038 Interest paid semiannually Par Value $1000 Market interest rate 10% What is the market value of the following bond? Coupon 9% Maturity date 2028 Interest paid semiannually Par Value $1000 Market interest rate 8% What is the yield to maturity of the following bond? Coupon 9% Maturity date   2027 Interest paid semiannually...
Recreate the above table in your own version of excel. At a rate of 4.5%p.a compounding...
Recreate the above table in your own version of excel. At a rate of 4.5%p.a compounding monthly, to repay the loan you see that 51 full repayments of $9,000 are required in addition to a smaller final repayment. If the interest rate is changed to 14.9% p.a. compounding monthly, how many full repayments of $9,000 will be required to repay the loan? (answer by rounding down to whole numbers to reflect full repayments eg 51)
create a GANNT chart for your company's public 15th anniversary party...preferably on excel
create a GANNT chart for your company's public 15th anniversary party...preferably on excel
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT