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

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top