Is it possible to make a pie chart from one cell with a fraction in it?
I tried, but the pie chart only seems to read the cell as one point or one value. I assume because it is looking for a table of data to process rather than a single cell that is the sum of all the data.
I put 5/6 in cell I9, inserted a 2d pie chart, hoping it would display a pie with 5 pieces cut out. But instead it only shows one small piece.
Apparently it's not as easy as I thought it would be.
Any suggestions for such a simple task?
Mike
Bookmarks