Richard has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Advanced - For Power Users course
Chart selecting additional data
I have a chart which has the axis label range "='Roster Approval Full'!$C$28:$C$64" and the data range "='Roster Approval Full'!$D$28:$D$64".
By my calculation that should show 37 bars on my bar chart.
However, although it IS showing the relevant 37 bars, it is also tagging on an extra 13 empty bars, so I have a load of white space to the right of my selection.
Has anyone come across this before or does anyone know why this might happen?
RE: chart selecting additional data
Hi Richard
I've tried to reproduce your question and didn't get any bars with blank labels. I used dates for my labels.
However if there are any duplicate labels then there are blanks.
To help answer your question could you say what axis labels you have for your chart?
Thanks
Doug
RE: chart selecting additional data
Hi Doug
The x-axis is a list of ward names...all unique of course, and no duplicates.
The y-axis is the number of days which is just a number against each ward.
Regards
Richard
P.s. I'm using Excel 2016 for this
RE: chart selecting additional data
Hi Richard
Thanks for reply.
Sounds puzzling. Would you be able to sent the worksheet to info@stl-training.co.uk and ask to forward to Doug?
If confidential perhaps you could change the label text.
Regards
Doug
RE: chart selecting additional data
Hi Doug
Thanks for the offer. When I opened the workbook just to check t before sending, there was no sign of the extra bars! Must have been in an odd state and sorted itself out after a restart.
Regards
Richard
RE: chart selecting additional data
Hi Richard
Glad it seems sorted now.
Regards
Doug
