As the title says, I cant seem to select multiple labels here. I select the cells with the labels in there, but it only ever allows the first one. Any suggestions?
Labels are in cells $B$31:$B$38, but it only ever shows the label in cell $B$31.
Using a clustered column chart, with 5 months for the clusters, then want to select the branch I need to for each label
thanks
Upload reference Sheet.
I agree that we may need to see an actual sample file to understand what you are doing and debug what is going wrong.
As a guess, I wonder if it is similar to this scenario: https://www.excelforum.com/excel-cha...ml#post4735253 In this case, the OP was correctly creating the chart, but Excel was completely guessing wrong at the desired ranges/series definitions. The solution was to go into the Select Data dialog after chart creation, verify the ranges that Excel decided to put into each field, and correct any mistakes that Excel made. Your scenario sounds like it might be similar, so I would recommend trying a similar solution.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks