Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting graph
i need to create a graph for the person that is selected by the user. i able
to code till it add the chart..however i gt a problem is that when i run the macro again, it will have an error unless i manually delete the graph that has been generated before running the macro again.following is my code. i was wondering am i able to code in a way that everytime i run tis macro, if there is a chart on the sheet, it will delete the chart first before creating another chart. Worksheets("Graph").Activate reqcol = Asc("A") + lastcol - 2 strreqcol = Chr(reqcol) strreqcol = strreqcol & endrow + 1 Range("B1:" & strreqcol).Select Charts.Add ActiveChart.ChartType = xlColumnClustered ActiveChart.SetSourceData Source:=Sheets("Graph").Range("B1:" & strreqcol), PlotBy:= _ xlRows ActiveChart.Location Whe=xlLocationAsObject, Name:="Graph" With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = strselected .Axes(xlCategory, xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle = False End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting graph
Dim cObj as ChartObject for each cObj in Activesheet.ChartObjects cObj.Delete Next ' remainder of your code. -- Regards, Tom Ogilvy "violet" wrote: i need to create a graph for the person that is selected by the user. i able to code till it add the chart..however i gt a problem is that when i run the macro again, it will have an error unless i manually delete the graph that has been generated before running the macro again.following is my code. i was wondering am i able to code in a way that everytime i run tis macro, if there is a chart on the sheet, it will delete the chart first before creating another chart. Worksheets("Graph").Activate reqcol = Asc("A") + lastcol - 2 strreqcol = Chr(reqcol) strreqcol = strreqcol & endrow + 1 Range("B1:" & strreqcol).Select Charts.Add ActiveChart.ChartType = xlColumnClustered ActiveChart.SetSourceData Source:=Sheets("Graph").Range("B1:" & strreqcol), PlotBy:= _ xlRows ActiveChart.Location Whe=xlLocationAsObject, Name:="Graph" With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = strselected .Axes(xlCategory, xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle = False End With |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
selecting graph
thanks so much..it work great...
"Tom Ogilvy" wrote: Dim cObj as ChartObject for each cObj in Activesheet.ChartObjects cObj.Delete Next ' remainder of your code. -- Regards, Tom Ogilvy "violet" wrote: i need to create a graph for the person that is selected by the user. i able to code till it add the chart..however i gt a problem is that when i run the macro again, it will have an error unless i manually delete the graph that has been generated before running the macro again.following is my code. i was wondering am i able to code in a way that everytime i run tis macro, if there is a chart on the sheet, it will delete the chart first before creating another chart. Worksheets("Graph").Activate reqcol = Asc("A") + lastcol - 2 strreqcol = Chr(reqcol) strreqcol = strreqcol & endrow + 1 Range("B1:" & strreqcol).Select Charts.Add ActiveChart.ChartType = xlColumnClustered ActiveChart.SetSourceData Source:=Sheets("Graph").Range("B1:" & strreqcol), PlotBy:= _ xlRows ActiveChart.Location Whe=xlLocationAsObject, Name:="Graph" With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = strselected .Axes(xlCategory, xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle = False End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
Can I make a graph to be a specific size? (actual graph) | Excel Discussion (Misc queries) | |||
Macro to make a graph: help selecting the data ranges. | Excel Programming | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel |