Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
plotting data in separate window
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
plotting data in separate window
Below is a macro I recorded. Don't try to run the macro because chart
Recorded macros don't run witthout minor changes. I'm using this example to show you the Where option. charts can either be created on an existing worksheet or on its own Sheet. Just to let you know in a macro Sheet referes to all types of sheets (charts, worksheets, ...) while worksheet referes to only the calculation sheets. Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:B2"), PlotBy:= _ xlRows ActiveChart.Location Whe=xlLocationAsNewSheet With ActiveChart .HasTitle = False .Axes(xlCategory, xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle = False End With "Sante Brucoli" wrote: Hello there! I'm trying to plot data readed secuentially from cells with a macro, but the image shall appear in a separate window/form... It is this possible? How I can do it? Thank you in advance!!! Sante Brucoli Aeropostal Airlines |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
plotting data in separate window
Thank you Joel! I'll try it, and will let you know!!!
Regards, Sante "Joel" wrote: Below is a macro I recorded. Don't try to run the macro because chart Recorded macros don't run witthout minor changes. I'm using this example to show you the Where option. charts can either be created on an existing worksheet or on its own Sheet. Just to let you know in a macro Sheet referes to all types of sheets (charts, worksheets, ...) while worksheet referes to only the calculation sheets. Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("A1:B2"), PlotBy:= _ xlRows ActiveChart.Location Whe=xlLocationAsNewSheet With ActiveChart .HasTitle = False .Axes(xlCategory, xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle = False End With "Sante Brucoli" wrote: Hello there! I'm trying to plot data readed secuentially from cells with a macro, but the image shall appear in a separate window/form... It is this possible? How I can do it? Thank you in advance!!! Sante Brucoli Aeropostal Airlines |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting 1 curve from 2 separate x-axis data | Charts and Charting in Excel | |||
can't open new worksheets in a separate window | Excel Discussion (Misc queries) | |||
Open separate window | Excel Worksheet Functions | |||
Open Workbook in separate window | Excel Programming | |||
Excel launches in a separate window | Excel Programming |