Hi Guys/Girls,
I have columns of Data. Months (March through to Dec), with Data under each heading (about 10 rows of Data). I have made a Graph (Bar Graph) out of March's Data, but as new data is entered into April, May, June columns etc, I want the Graph to refer to the new months data, and subsequent months as the year goes on. I have seen Graphs that you click on and it changes the data. i am not sure if thats what I need. Any quick ideas.
cheers Jason
I have columns of Data. Months (March through to Dec), with Data under each heading (about 10 rows of Data). I have made a Graph (Bar Graph) out of March's Data, but as new data is entered into April, May, June columns etc, I want the Graph to refer to the new months data, and subsequent months as the year goes on. I have seen Graphs that you click on and it changes the data. i am not sure if thats what I need. Any quick ideas.
cheers Jason