98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Chart selecting additional data
Chart selecting additional data
Resolved · Urgent Priority · Version 2010
Tue 27 Dec 2016, 14:46Delegate Richard said...
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?
Tue 3 Jan 2017, 10:51Trainer Doug said...
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
Tue 3 Jan 2017, 12:00Delegate Richard said...
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
Tue 3 Jan 2017, 12:28Trainer Doug said...
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
Tue 10 Jan 2017, 12:09Richard (guest) said...
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
Mon 16 Jan 2017, 12:12Trainer Doug said...
RE: chart selecting additional data
Hi Richard
Glad it seems sorted now.
Regards
Doug
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the default location for opening and saving spreadsheetsIf you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to. |
