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.

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.
>
>