Re: Creating/programming an Excel dynamic graph

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/29/04 

Date: Sat, 29 May 2004 16:12:32 +0200

Hi
see:
http://www.tushar-mehta.com/excel/software/autochart/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html 

--
Regards
Frank Kabel
Frankfurt, Germany
> Hi,
>
> I'm facing a problem at the moment that with my own knowledge i can't
> solve at the moment and it drives me crazy.
>
> I would like to create an Excelsheet in which an unknown amount of
> variables can be entered, to which a value is assigned. So say i have
> 20 variables for my case, i want to enter 20 variable names in a cel
> and then assign either the value 1,2 or to those variables, which in
> my case means the level of impact of the variable. So in column A i
> have my 20 variable names, in column B my 20 impact values. In column
> B I also apply conditional formatting to make the cell color change
> depending on the entered inmpact value (1=green, 2=orange, 3=red).
>
> What I'd now like to do is have some programming logic that is able
to
> create a graph with my 20 variables on the x-axis (and in general the
> amount of variables for a graph is variable) and has the impact
values
> on the y-axis. Point of the graph should be to show variable 1 has
> impact 2 (and I would like the color of the corresponding bar to be
> orange in this case), variable 2 has impact 1 and has a green bar
with
> height 1 on the y-axis.
>
> Is this possible with visual basic or is there a better solution to
my
> problem? I would greatly appreciate any help!
>
> Thanks,
>
> regards
>
>
> ---
> Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Creating/programming an Excel dynamic graph
    ... also apply conditional formatting to make the cell color change ... amount of variables for a graph is variable) and has the impact values ... variable 2 has impact 1 and has a green bar with ... height 1 on the y-axis. ...
    (microsoft.public.excel.programming)
  • Re: Court authorized wiretaps in the U.S. surged last year
    ... >> Draw a graph. ... Y-axis is how much harm is done to the users of those drugs. ...
    (sci.electronics.design)
  • Re: MSGraph Bars not drawing in right proportion
    ... I had already cleared the walls and Y-axis, so there was no y-axis to click ... It IS available for sametype of graph in Excel chart options, ... not bar - Chart Type ... there is specific Scale tab available for Y-axis in Column ...
    (microsoft.public.access.reports)
  • Re: rounding a number
    ... make a graph. ... The y-axis is dependent on the result of the ... goto 123 ... !finding axis location (location of first grid line) ...
    (comp.lang.fortran)
  • y-axis titles get cut off
    ... When I make a graph in Excel, ... in the title for the y-axis, and depending how long it is, the last ... Does anyone know why this happens, and how to fix it? ...
    (microsoft.public.excel)