Offset / slider returning 0's (x13) at the end of the data

Resolved · High Priority · Version 2013

Fri 1 Sep 2017, 11:44 Delegate Carl said...

Carl has attended:
Excel Dashboards for Business Intelligence course
Excel VBA Introduction course

Offset / slider returning 0's (x13) at the end of the data

Hi

My slider is using an offset function and at the end of the slider there are 13 0's.

How do I get these to disappear?

thanks

Mon 4 Sep 2017, 14:57 Trainer Richard said...

RE: Offset / slider returning 0's (x13) at the end of the data

Hi Carl,

Thank you for using the forum to ask a question.

Please can you checked the formatting of the source data for the slider?

If that's not resolving the issue, it's a more specific problem to the configuration of your dashboard. I can refer the question to one of our Dashboard Trainers.

Kind regards

Richard Bailey
Microsoft Certified Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 11 Sep 2017: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips