Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting Graph
Hi again,
I'm having a problem exporting a graph to a defined location. Sub cumulative_data() Sheets("cum_data").Select Start = 2 t1 = Sheets("cum_data").Cells(Start, 1).Value t2 = Sheets("cum_data").Cells(Start, 2).Value TheTitle = t2 & " " & "-" & " " & t1 Set MyRange = Range("C1:AM5") MyRange.Select Fname = "C:\" & t2 & _" & "cum" & ".gif" Call Cum_data_graph End Sub Sub Cum_data_graph() ' ' This macro makes a line graph ' <Snip bit that works that generates the graph <heres the problem line ActiveChart.Export Filename:=Fname, FilterName:="GIF" Fname is defined in Sub cumulative_data() and stepping through code it returns "C:\29H111_cum.gif" which is correct. Now I was calling the graph at work in a different manner "Call W075_Spend("C1:AM5", "Project Short Term Overall", "C:\overall.gif")" which worked fine. The problem seems to come from trying to define Fname in Sub cumulative_data() and having it read it in Cum_data_graph(). Ric |
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 | |||
Exporting Excel Graph to PowerPoint or Flash | Charts and Charting in Excel | |||
Exporting from Access to Excel issue - blank graph view | Setting up and Configuration of Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
exporting graph into a jpeg or bmp format | Charts and Charting in Excel |