G Guest Aug 12, 2005 #1 How do I exclude the last three rows of a graph that is automatically refreshed?
E Earl Kiosterud Aug 12, 2005 #2 Really, You can change the source data to not include the last three rows. A macro could do that. Or you could use Tools - Options - Chart - Visible cells only, and hide the rows .
Really, You can change the source data to not include the last three rows. A macro could do that. Or you could use Tools - Options - Chart - Visible cells only, and hide the rows .
T Tushar Mehta Aug 13, 2005 #3 How do I exclude the last three rows of a graph that is automatically refreshed? Click to expand... In addition to Earl's suggestions, you could also used a named formula. See Dynamic Charts http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions
How do I exclude the last three rows of a graph that is automatically refreshed? Click to expand... In addition to Earl's suggestions, you could also used a named formula. See Dynamic Charts http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions
