Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
REPOST: Automating series generation for scatter plots
This question is a repost of my 5-30-06 question.
I need help in automating series generation in a workbook full of scatter plots. My data is in the sheet €śData€ť and is formatted as seen below, with the date in column A, the series in column B (already sorted), and 20 columns of measurements (I am just showing A and B here). The upper and lower limits of each measurement are in the same column as the data collected, with a space separating them. What I need to do is graph the data from the upper and lower limits and the oven number as different series on each of my 20 charts, with the date as the x-value. The charts are named according to the measurement column. For example, the data in Measurement A is plotted in sheet €śMeasurement A€ť. The amount of data to be charted can vary greatly, so I need to have some kind of if statement, where if the oven is 1, then it goes into series 1 on the graph, instead of specifying data ranges. I am not sure how this affects matters, but not all oven numbers are always represented in the data. I am a VBA newbie and this is out of my range. Can anyone help provide me with some sample code to follow along with? I am using Excel 2002. Date Oven Operator Measurement A Measurement B 4/11/2006 1 Teresa/Dave -0.031 0.04 4/11/2006 1 Teresa/Dave 0.005 0.082 4/11/2006 2 Teresa/Dave -0.031 0.04 4/11/2006 3 Teresa/Dave 0.005 0.082 4/12/2006 4 Teresa/Dave -0.026 0.022 4/12/2006 4 Teresa/Dave -0.026 0.022 4/13/2006 5 Greg -0.027 0.019 4/13/2006 6 Teresa/Dave 0.018 0.044 4/13/2006 7 Teresa/Dave 0.018 0.044 USL 0.06 0.09 USL 0.06 0.09 USL 0.06 0.09 USL 0.06 0.09 LSL -0.06 -0.09 LSL -0.06 -0.09 LSL -0.06 -0.09 LSL -0.06 -0.09 Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scatter plots with multiple series | Charts and Charting in Excel | |||
Semi-automating the generation of multiple cell range names | Excel Discussion (Misc queries) | |||
Automating series generation for scatter plots | Excel Programming | |||
Excel gives me line plots - I want scatter plots | Charts and Charting in Excel | |||
automating chart generation from text files | Excel Programming |