multiple series

  1. M

    Dynamic Charts from data with multiple Series

    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...
  2. A

    Create graph with multiple categories

    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...
  3. E

    Creating charts with multiple data series (in a loop)

    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...
  4. D

    VBA to automatically add series to funnel plot

    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...
  5. S

    Scatterplot with multiple x and y values.

    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...
  6. T

    Creating an X,Y scatter plot with columns sorted as (series name, x, y)

    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...
  7. N

    selecting data, and plotting multiple series

    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...
  8. P

    Graphing multiple series over time

    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...
  9. S

    Dynamic Line Graph, Multiple Series

    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...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top