Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Auto Populate a cell with a chart based on a value
Yes you can. the size can only be a scale factor to the present size. To
double the size enter 2, to make half .5 Enter a simple chart such as A B 1 A 1 2 B 2 3 C 3 4 D 4 1) Create chart above 2) Copy Subroutine below 3) Go to worksheet and right cllick tab (normally sheet1) on bottom of worksheet 4) Select View Code 5) Past code into VBA window 6) go back to worksheet and enter any number in cell E10. Sub Worksheet_change(ByVal Target As Range) If (Target.Row = 10) And (Target.Column = 5) Then ActiveSheet.Shapes("Chart 1").ScaleWidth Target, _ msoFalse, msoScaleFromTopLeft ActiveSheet.Shapes("Chart 1").ScaleHeight Target, _ msoFalse, msoScaleFromTopLeft End If End Sub "Bryan" wrote: I have a number of values (example: H 25%, H 50%, H 75%) in separate cells on column. There are 30 in total. I would like my team to enter one of the values in a separate cell which would then pre-populate a chart based (also within the spreadsheet) on that value. The theory is that the higher the sales stage/value, the larger the graph gets. Is this possible? I'm a novice in excel so, please be as basic as possible. Any assistance ASAP would be greatly appreciated. THANK YOU. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to auto populate many cells based on one cell | Excel Discussion (Misc queries) | |||
How to auto-populate worksheet based on cell entry? | Excel Discussion (Misc queries) | |||
Auto populate a cell based off a look up table | Excel Discussion (Misc queries) | |||
How do I Auto Populate a cell with a chart based on a value | Excel Worksheet Functions | |||
HOW ?Excel chart auto insert /populate a code based on date | New Users to Excel |