Microsoft Office Questions? Ask a IT Expert for Support ASAP
I was affraid of that, I was just hoping that it would be something like inserting a comment and then putting the graph in the comment linked to data in the defined column or row so that it would update to what is in either the row or column when you run your curser over the cell. Sounds like it should be simple but if it cant be done then it cant be done. I have found a way to make the graph and then link it to the cell so I have to click on the cell. Then I would have to close it when I finished viewing it. I would have to do that with each graph I wanted to see. . Each column would represent one bill, utility, etc. the rows would be each month. I was wanting to put one line graph comment at the end of each column to show a graph of the data on each column to watch usage of that bill and a pie graph at the end of each row so the overall demand for each month. Neat idea but if it cant be done then it cant be done. Thanks for trying. Perhaps it is possible with a different version of excel.