R rosin New Member Aug 19, 2011 #1 I have a list of 10 tasks with check boxes, when i make a chart i have 10 bars in my chart. How can i make a thermometer chart to show progress once the checboxes has been ticked ie. 1 tick = 10%, 2 ticks = 20% etc Can anyone help?
I have a list of 10 tasks with check boxes, when i make a chart i have 10 bars in my chart. How can i make a thermometer chart to show progress once the checboxes has been ticked ie. 1 tick = 10%, 2 ticks = 20% etc Can anyone help?
J JP New Member Aug 19, 2011 #2 Does this help? http://spreadsheetpage.com/index.php/tip/creating_a_thermometer_style_chart/
Hui Excel Ninja Staff member Aug 20, 2011 #3 Or have a look at http://chandoo.org/wp/2011/04/13/how-to-make-a-5-star-chart/ Add gridlines to the chart
Or have a look at http://chandoo.org/wp/2011/04/13/how-to-make-a-5-star-chart/ Add gridlines to the chart
