dynamic range charting with 2 series

**rbriceno** · 05-23-2012, 01:31 PM

Hello users of this amazing forum. I was able to produce a dynamic range graph with one series (as represented in the graph sheet of the attached excel). However I would like to add a second set of observations. The second set was introduced in the sheet called "liq". For all the "individuals" the range of data is the same, since I'm using as Xvalues the dates where the bonds are valid and as Y values the observations available in these same dates.

Can somebody just give me a hint about how to introduce the second data series that is in the second sheet. The idea is to scroll and to get both series graphed at the same time.

Thanks for your help!

**dilipandey** · 05-23-2012, 01:39 PM

Hi rbriceno,

Would it be right click on chart -> select data -> Insert series .. this will introduce the another set of data series.
If you face issue there, let me know which series you want to add to the chart and highlight those in workbook.. thanks

I notices that you have Prom column C is already into your chart.. what else you need?

Regards,
DILIPandey

<click on below 'star' if this helps>

**rbriceno** · 05-23-2012, 02:09 PM

Hi dilipandey. In sheet "liq" I did what you recommended, but then just 1 series start to move (the red one doesn't change). I highlighted in yellow both series that should be graphed. Thanks for your help.

**rbriceno** · 05-23-2012, 02:46 PM

Here is the excel file with highlighted columns (in both graf and liq sheets. Sorry (I'm new to posting)

**dilipandey** · 05-26-2012, 06:14 AM

Hi rbriceno,

Where are the two highlighted columns ... are they one column per sheet as I can figure out?
Do you want to move chart as per these two columns with the help of scroll?

I see lots of formulas / logics used there and not sure about them entirely, would suggest if you want to graph two series then let me know where are those two series.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>