plotting charts
I have a chart in a worksheet and it pulls it information from the same
worksheet. The amount of items may vary in the chart so i need to be able to plot just the cells with information in them instead of having a huge graph that is plotting all the cells. The format of my worksheet does not change. |
plotting charts
Hi,
See here for details on dynamic ranges. http://peltiertech.com/Excel/Charts/Dynamics.html http://www.tushar-mehta.com/excel/ne...rts/index.html Cheers Andy enyaw wrote: I have a chart in a worksheet and it pulls it information from the same worksheet. The amount of items may vary in the chart so i need to be able to plot just the cells with information in them instead of having a huge graph that is plotting all the cells. The format of my worksheet does not change. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 03:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com