Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for coming back to me.
FY13/14 etc refers to the financial years that will form the x axis.
Essentially there are two blocks of data that I wish to plot (1. number of units by recurring revenue contracts / capital sales / maintenance, and 2. revenue by recurring revenue contracts / capital sales / maintenance).
I would like the the y axis on the left hand side of the graph to reflect the units, and this data to be presented in a stacked bar chart. Whilst the y axis on the right hand side to reflect the revenue (£000), with three lines (recurring revenue contracts, capital sales and maintenance).
I have attached what I have achieved so far!
Hopefully this makes sense.
Each value must be kept separate - so for the stacked bar chart (to show units) there should be three different coloured stacks, which tie into the y axis on the left.
Then for the revenue there should be a separate line for each set of values (i.e. recurring revenue contracts, capital sales & maintenance), which ties into the y axis on the right.
This is ridiculous. This is one of the set of instructions I tried to follow which wouldn't work - which is why I contacted you.
A complete waste of my time and money. Are we able to speak so that you can guide me through the instructions?
When I click on the chart I do not get, go to the format tab I do not have the opportunity to get a secondary axis.
I still need help - can we speak rather than do this by email?
That sounds like a good idea. Thanks.
We are connected