Dropdown box with Chart

The UK's most regular instructor-led training courses.
Training information: learn excel in london · Excel courses london · Microsoft Office VBA training

Resolved · Low Priority · Version Standard

Jingxin has attended:
Excel VBA course

by - delegate Jingxin [1 post] (2008 Mar 27 Thu, 12:03) Reply

How could I choose twe data from two dropdown boxs then a chart about these data will be displayed? Is anyone has some examples similar as that? Thank you very much.

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Dropdown box with Chart

by - trainer Jacob silver contributer [89 posts] (2008 Apr 30 Wed, 17:08) Reply

Hi Jingxin

Thanks for your post. By the brief you have supplied it looks like this may well fall into a consultancy area.

3 steps to organising consultancy

1) email us some examples of your work, and list your key objectives). we will then profile & review your requirements

2) We will then send you a proposal
- Scope of work
- Timeframes
- Pricing

3) Sign our consultancy agreement

If you wish to progress this then please let us know.

Regards

Jacob

· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Microsoft Excel Training - Numerical excellence for all
· Microsoft Excel's Best Kept Secret
· A Beginners Guide To Formulas In Excel
· Features of Microsoft Excel that assist in Analysis of Financial Data

Please browse our web site to find out more about
learn excel in london and other Microsoft training courses.

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.