I don't know why it would be cheating, it does seem to work, but I need to create extra columns on the worksheet for average, and if I hide the column the graph won't work. What if i wanted to modify my graph slightly, and show a goal line along with the average. Lets say the goal was 100, how can I have the graph display a horizontal line across it at the totals 100 value, along with my average marker, the horizontal line at about 68? Thanks
|