Graphs

[T Boucher]

How do I get the graph to automatically update without selecting the data every time. I moved the graphs to their own sheet.

[Kaper]

Try to use table (Ctrl+T) as your source data then build graph based on table. If not enough/not working for you see http://www.techrepublic.com/blog/mic...arts-in-excel/

PS. Next time try to write a more detailed title for the post - see basic suggestions in forum rules

[T Boucher]

I formatted the data as a Table. The graphs are linked to the data but the x axis does not display the data that I selected. As can be seen on the cumulative size distribution sheet and rosin rammler sheet. I used an IF function for displaying varies number of sieves that can be selected by the user. Please help.

[T Boucher]

Thank You for the Help Kaper! I will remember that in the future!