Do all users need to have access to the external database to view data included in the chart?
Not necessarily. The credentials will be provided by a single user and presented in the parts without requiring additional credentials from the user viewing the charts. If you decide to use Windows Authentication as the mechanism to access the external database, then the user must have access to the external database.