Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

dynamic chart

Avatar of Rodrigo_Briceno
Rodrigo_BricenoFlag for Costa Rica asked on
Microsoft Excel
12 Comments1 Solution267 ViewsLast Modified:
Hi excel experts. I was reviewing the database of previous questions made to this site and I found one interesting reference, that is closely related with the question I need to solve. The question itself referred to the use of dynamic named ranges and was applied to presenting a graph (from 1 row to more than 1,000 rows). I need something similar, but this time some changes are required. First of all the row with dates must be fixed for all the series to be presented on the graph. In second place, I need to present consecutive rows of data each time that I use the scroll (from a to e). I need a line graph for presenting the data. Attached the data. Thanks for your help.
Book1.xlsx