Change the chart when a cell is clicked

S

SheriTingle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart moves on plot area when adding a third month 2
Clustered Stacked Chart 1
change chart column colors 1
Combine 2 Charts 2007 Excel 1
How to create a chart that compares monthly data with an average 4
Line and Point in the same chart? 2
Need to create a chart with 4 parameters 2
Scatter plot 1

Top