Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-08-2019, 05:09 AM   #1
DoneganF
Newly Registered User
 
Join Date: Aug 2012
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
DoneganF is on a distinguished road
List box Chart Selection

I have a list box which contains division names. I have that list connected to 4 charts, so that when I select a specific division, all 4 charts display the data for that division. It works exactly as I expect it to. However, when I handed the file off to my boss (also using Excel 2016) when he clicks on an item in the list, the charts are not updating.

I'm really stumped. Any help is greatly appreciated.

DoneganF is offline   Reply With Quote
Old 11-08-2019, 05:42 AM   #2
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,380
Thanks: 115
Thanked 3,112 Times in 2,830 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: List box Chart Selection

It may not be a trusted document for your boss.
Does any code work? If not, does the security warning bar appear?
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 11-08-2019, 06:11 AM   #3
DoneganF
Newly Registered User
 
Join Date: Aug 2012
Posts: 25
Thanks: 5
Thanked 0 Times in 0 Posts
DoneganF is on a distinguished road
Re: List box Chart Selection

He did make it a trusted site - and all the other macros are working as expected.

DoneganF is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Selection list in form. Values from a table depend on selection from different table JoeyJoystick Forms 3 07-28-2015 01:49 AM
[SOLVED] combobox selection list not updating after each selection Twinnie Forms 4 10-31-2014 02:06 AM
List Box - Selection - Populates next List Box whhaatt Forms 12 09-06-2013 04:39 PM
Chart from multiple selection prashiel Queries 0 04-30-2009 02:53 AM
Multiple Selection List Box on Form & saving selection delilah84au Forms 0 10-08-2006 10:45 PM




All times are GMT -8. The time now is 12:52 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World