| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excluding data from automatically refreshed charts
How do I exclude the last three rows of a graph that is automatically
refreshed? |
|
#2
|
|||
|
|||
|
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 . -- Earl Kiosterud www.smokeylake.com "Reallydumb" wrote in message ... How do I exclude the last three rows of a graph that is automatically refreshed? |
|
#3
|
|||
|
|||
|
In article ,
says... How do I exclude the last three rows of a graph that is automatically refreshed? In addition to Earl's suggestions, you could also used a named formula. See Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel | |||
| Urgent help! how to automatically resize all the charts? | Excel Worksheet Functions | |||
| How do I automatically transfer data to a 2nd worksheet page? | Excel Worksheet Functions | |||
| Automatically pull data into another worksheet within the same fil | Excel Worksheet Functions | |||
Linear Mode
