Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to plot charts of 1000 records automatically possible?
my data
name size length 0min 3min 10min chart A 3 5 1 10 3 B 5 2 2 4 3 C 4 3 3 9 6 .... Is it possible to use a macro to plot a chart of 0 to 10 mins for each entity (charts A, B, C, ...) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to plot charts of 1000 records automatically possible?
Hi Ross,
Hi Peter, Loop through each row. Build Chart. Save Chart. I have a worksheet that does this on my charting page at http://edferrero.m6.net/charting.aspx look for 'Multiple Chart Builder' (hint: its down the bottom). The workbook saves each chart as a .gif file in a folder of your choice. Ed Ferrero http://edferrero.m6.net/ my data name size length 0min 3min 10min chart A 3 5 1 10 3 B 5 2 2 4 3 C 4 3 3 9 6 ... Is it possible to use a macro to plot a chart of 0 to 10 mins for each entity (charts A, B, C, ...) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to upate the charts automatically | Charts and Charting in Excel | |||
Is there a macro to create charts automatically? | Charts and Charting in Excel | |||
How to Automatically Create Scatter Plot Charts | Charts and Charting in Excel | |||
how do i plot data consisting of 1000 lines in excel sheet | Charts and Charting in Excel | |||
how do I see more than 1000 records filtered | Excel Discussion (Misc queries) |