I have been working on a set of data for monthly hours spent per client per category, my boss would like this displayed in a stacked bar chart.
Unfortunately I cannot work out how to display the correct things on the axis. Rather than getting a clients name on the vertical axis, I get numbers, and I cannot seem to format the time on the horizontal axis to be in increments of five.
If someone could help explain this to me I would be very appreciative, as it is frustrating and making me feel useless in my job.
I have uploaded a file to make sense of it all.
I have tried selecting data ranges, changing how the chart is displayed, even changing chart type (though I do need the stacked bar).
Thank you in advance for any assistance/explanation you can provide to help.
Bookmarks