multiple series

I have numerous x/y series that aren't regularly sampled, I need to create an average of these series on a regularly sampled output. Here's the beginning of 3 example series: x1 y1 x2 y2 x3 y3 2.055 1542.36 1.013 1540.924 1.185 1541.119 3.077 1542.382 2.028 1540.778 2.002 1541.082 4...

Currently manually updating about 30 charts monthly. Adding new data monthly. Would like to make charts dynamic I would like to use the offset function and named ranges. I can get as far as one dimension and one series but I am stuck as to how to use both series (revenue and volume). But I...

Hi all I am trying to create a scatter plot in excel and I am getting my rear kicked for such a simple procedure. My problem is I have a lot of data that needs to be compiled in a scatter plot and doing it manually will not be an option. My data kind of looks like this <colgroup><col><col...

Dear All, I am struggling trying to set up a code in VBA to create a chart in the active w/s. This chart should be a scatter line with no markers. The x values are constant for all the series (column A from A19 - the end will be dynamic). The y values will vary. The number of series will also...

Hello All, I’m 100% naïve to VBA so please excuse me if I appear stupid with my questions. I have a table where 1 part is used to draw control limits (upper and lower) as a funnel plot using scatter chart as a base graph. The second part of the tables contains a set of certain values that...

Hi, I have a question regarding a way to organize many scatter plots 'easily'. I am working on improving it to handle different time series and have not found a simple way for it to auto-update yet. let's say I would like to compare 500 time series that look something like this...

I am trying to create a x,y scatter plot of multiple series, each with their own x,y values. The data is organized as shown below, as (series name, x, y). I can create the scatter plot by adding each series to the chart, but there are hundreds of series and I need a faster way to go through...

I am writing a macro to create an xy-scatter plot. I have selected the range that I wish to plot. I have several series that I would like to be included in the plot (the specific number of series will vary each time and the number of points). I am having trouble with the...

Hey, Any idea how I can show the following in one chart (or any other better way?): August 3rd: sizes____apples________ oranges 1lb ________5 ___________8 2lb ________6___________ 9 3lb ________4___________ 6 4lb ________6___________ 9 etc. August 4th: sizes 1lb ________4...

Hello, I am trying to created a line graph with 12-13 series that you can interact with. Like this graph below: http://img59.imageshack.us/img59/5582/excelhelp.jpg I would like to be able to created a line graph where you can zoom in 5 yrs, 10 yrs, etc. Everything I choose from a drop down...