| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change the chart when a cell is clicked
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change the chart when a cell is clicked
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change the chart when a cell is clicked
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Textbox values won't change untill clicked on!!!!!!!!!! | Excel Discussion (Misc queries) | |||
| Change Macro button color after clicked | Excel Discussion (Misc queries) | |||
| why is the chart displayed only when the chart area is clicked on? | Charts and Charting in Excel | |||
| Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
| can't get to change from portrait to landscape even after clicked. | Excel Discussion (Misc queries) | |||
Linear Mode
