Excluding data from automatically refreshed charts

R

Reallydumb

How do I exclude the last three rows of a graph that is automatically
refreshed?
 
E

Earl Kiosterud

Really,

You can change the source data to not include the last three rows. A macro
could do that. Or you could use Tools - Options - Chart - Visible cells
only, and hide the rows .
 

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

Excluding a paragraph tag from spelling check 0
exclude certain data 1
Filtered view of Visio Chart 0
Turning off automatic calculation 0
How to automate update on weekly reports spreadsheet 0
XY Charts Excluding Weekends 1
Excel 2007 charts: want to avoid zero values 1
Automatic Macro to create 200 graphs 1

Top