Data Range

W

Will

My data range for my chart is =Charts!$A$4:$C$28
How would I change the formula so the chart would update
as I add data from line 29 down to say line 40.
I would change my range from A4:C28 to A4:C40, but don't
want all the null data points.
Thanks..........Will
 
T

Tushar Mehta

For one possibility, check the Excel | Tutorials | 'Dynamic Charts'
page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Data Range Question 1
Graph to display Range Label and Mean 0
data range referrences 28
Odd Chart Format Results 1
Static Chart Data Range 2
How do I update charts in excel 2007 2
Adding a line to a population bar chart 0

Top