# Charting multiple dynamic ranges as a single continous series

1. ## Charting multiple dynamic ranges as a single continous series

Hello! I'm having a charting/graphing question. I have a log where I'm recording daily readings of a pipette. Each day three readings are taken and I have each stored as a dynamic range so that I can monitor how in control my process is. However, when I graph it, I would like it to be one continuous line graph (Three readings from day one followed by three readings from day two, etc.). I'm having difficulty doing any sort of combination. Any help/advice would be great. Thank you!

2. ## Re: Charting multiple dynamic ranges as a single continous series

You could create a 4th range by concatenating the first three... The formula would be along the lines of :-

= Formula1 & "," & Formula2 & "," & Formula3

It would probably be quite long and difficult to manage but cut and paste should do the trick for you...

3. ## Re: Charting multiple dynamic ranges as a single continous series

Thanks for responding! I tried creating two new dynamic ranges, for the x values and the y values. However, when i created a line graph using these two ranges, the graph is completely blank and I cannot see my data anywhere. I'm not sure where I went wrong haha!

4. ## Re: Charting multiple dynamic ranges as a single continous series

If you go to the function manager, select your dynamic range and put the cursor in the edit box Excel will highlight the calculated range in the same way it does for copy/paste... That way you can validate your functions... Also recheck the series in the chart -

5. ## Re: Charting multiple dynamic ranges as a single continous series

ok, when i put the cursor in the edit box, no cells are being highlighted so i'm assuming i haven't written the combined range properly. My two pre-defined names are "First" and "Second" so the combined name that I made for them is

=Data!First&","&Data!Second

Does that seem to be correct?

6. ## Re: Charting multiple dynamic ranges as a single continous series

No ... you need to put the actual functions that define them in...

7. ## Re: Charting multiple dynamic ranges as a single continous series

hmm, i had tried that originally and that didn't work either

8. ## Re: Charting multiple dynamic ranges as a single continous series

That is most likely Syntax error stemming from combining the formulas - Function manager doesn't help much in telling you why the function is rejected - try it in a worksheet cell (which will deliver an output error) but makes editing easier

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1