Hi. I have a problem in labeling my vertical axis from just 1, 2, 3, 4, 5, 6 to what I intended which is eg EL, VZ, LK, SC, GN, SK.
I apologize if this question has been posted but I can't seems to find any relevant solution..
Appreciate any helpattached is my excel.
Thanks!
You are setting the Name of the series to
='MTD - Aug''09'!$K$17:$P$17
instead of the Category labels.
but 'MTD - Aug''09'!$K$17:$P$17' is the cells with the data I wish to appear on the axis..
Isn't it correct?
Surely your data is in row 18?
Ohhh Thanks Andy! I get what you mean.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks