Change the chart when a cell is clicked

's Computer Specifications

Hello and thanks for the help. I am using Office 2007. I have a sheet with 8
people listed and their sales. Here is a brief example:

Rep Jan Feb Mar
JO 5 6 7
AL 65 3 2
KIM 6 2 9

I would like to click on the cell that says JO and have the Jan, Feb, Mar
data appear on the page as a pie chart. When I click on AL then the Jan, Feb,
Mar data for AL appears and when I click on KIM the Jan, Feb, Mar data for
Kim appears. I would like for JO's chart to disappear when I select AL and
AL's chart to disappear when I select KIM.

's Computer Specifications

Hi SheriTingle,

I have a sample that pretty much does what you are asking at;
http://edferrero.com/ExcelCharts/tabid/102/Default.aspx

Look for 'Chart Selector' and/or 'Chart Selector Version 2' and download it.

Ed Ferrero
www.edferrero.com

's Computer Specifications

A modern Excel 2007 way:
http://c0718892.cdn.cloudfiles.racks...03_31_10a.xlsx
Pdf preview:
http://c0718892.cdn.cloudfiles.racks.../03_31_10a.pdf

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change cell font color when cell is clicked	aileen	Microsoft Excel Programming	9	27th Apr 2010 08:53 PM
Print Preview chart when chart is clicked request.	joecrabtree	Microsoft Excel Programming	1	20th Nov 2007 02:00 PM
how do I create a chart with cells that change when clicked on?	=?Utf-8?B?RGlnaVBpY3MgRGVzaWdu?=	Microsoft Powerpoint	3	2nd Oct 2007 01:17 PM
Change cell value when right-clicked/double-clicked	grime	Microsoft Excel Programming	5	17th Oct 2005 01:52 PM
Scrollbar on Chart Jumps to Left when Chart is Clicked	Bob	Microsoft Excel Charting	5	1st May 2005 02:06 AM