Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create graphic autmatically with VB
Hello I need your help for create graphics. I create graphics from a page with many source data For example: avril mai juin ent 1 2 1 12 ent2 36 2 444 ent3 63 365 111 ent4 3 2 545 avril mai juin ent1 1 2 23 ent2 2 36 22 ent3 5 252 22 ent4 2 2 214 My probleme is with the data capture. This the code Charts.Add ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:= _ "Courbe - Histo. 2 axes" ActiveChart.SetSourceData Source:=Sheets("Feuil1").Range("B2:E6"), PlotBy:= _ xlRows ActiveChart.Location Whe=xlLocationAsObject, Name:="Feuil2" I think taht the "RAnge("B2:E5")" must not be fixed but it could be like "Range("case1:case2")", With case1=A2 then case1=A2+5 i.e. case1=A7 Like wise for case2=E5 then case2=E5+5 i.e. casee2=E10 The number of source data is not fixed, the function had to stop when it is no more value. I try to do somethong like: "Ifcase1<Activesheet.UsedRange.Rows.Count then go to begin" with begin tehe beginning of the buckle,but i need the field "case1". So if need be, i can give you an example. Thanks for your help Elve PS: excuse me if my english is not perfect i am french... -- Ce message a ete poste via la plateforme Web club-Internet.fr This message has been posted by the Web platform club-Internet.fr http://forums.club-internet.fr/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering of data - autmatically based on data on other sheet | Excel Discussion (Misc queries) | |||
Axes values changes autmatically / textboxes lose formatting | Charts and Charting in Excel | |||
Create a Macro to give movement to a graphic. | Excel Discussion (Misc queries) | |||
About lineal graphic | Charts and Charting in Excel | |||
how do i create and save a new file or worksheet autmatically ever | Excel Discussion (Misc queries) |