Hi, I am really frustrated using excel 2010. The older version no problem knew it inside out,
Can someone help me with the following.
1. When using the graph if I want to repeat an action .so when I change a line I want the other lines to change, I used to do this using the F4 key . any thoughts ?
2. Source data - an old function in excel. I have a graph but want to copy this and use the data below, I am using several variables - eg. Total, target, Eng so i am unable to copy and drag the data down to the next row. HELP ? this will save a lot of time.
3. I have an age group that i would like to use. eg. 5-9 If I type this in the legend entry and use '5-9 the Apostrophe appears in the graph else it will appear as a date ?
4. The title - any way to move this horizontally so everything fits on one line, at mo i reduce the text.
prob basic stuff but I want to do it quicker rather than wasting time.
Help please
thanks
Can someone help me with the following.
1. When using the graph if I want to repeat an action .so when I change a line I want the other lines to change, I used to do this using the F4 key . any thoughts ?
2. Source data - an old function in excel. I have a graph but want to copy this and use the data below, I am using several variables - eg. Total, target, Eng so i am unable to copy and drag the data down to the next row. HELP ? this will save a lot of time.
3. I have an age group that i would like to use. eg. 5-9 If I type this in the legend entry and use '5-9 the Apostrophe appears in the graph else it will appear as a date ?
4. The title - any way to move this horizontally so everything fits on one line, at mo i reduce the text.
prob basic stuff but I want to do it quicker rather than wasting time.
Help please
thanks