Don't use Excel much but have been having a play with it.
I'm trying to find the box, 'Add Chart Elements', which is supposed to be under the Home tab. Maybe because my version is 2007 and the book I'm learning from is 2022 that things have changed a bit. I'm trying to work with 'axis', which they call 'axes' which doesn't help.
The only way I can find it is if I load a chart, right click on the chart and then click 'Select Data'. This brings up the bar across the top called 'Chart Tools'.
From here I can access various tabs that cover; layout, design, review etc The axes is in the layout tab.
My question is, How can I get this toolbar to stay at the top of my Excel sheet permanently? Once I've used the function to do something, it closes back to the normal toolbar, and the only way to access it again is to load another chart. Which obviously defeats the whole object of working on one single chart.
I'm trying to find the box, 'Add Chart Elements', which is supposed to be under the Home tab. Maybe because my version is 2007 and the book I'm learning from is 2022 that things have changed a bit. I'm trying to work with 'axis', which they call 'axes' which doesn't help.
The only way I can find it is if I load a chart, right click on the chart and then click 'Select Data'. This brings up the bar across the top called 'Chart Tools'.
From here I can access various tabs that cover; layout, design, review etc The axes is in the layout tab.
My question is, How can I get this toolbar to stay at the top of my Excel sheet permanently? Once I've used the function to do something, it closes back to the normal toolbar, and the only way to access it again is to load another chart. Which obviously defeats the whole object of working on one single chart.