Excel 2007 chart
I have a spreadsheet with data in col b starting at row 1 and continuing down
to row 10. I want to have a chart depict the values in row 1 to 100 as I will be adding data as time goes by. The trouble that I am having is that although there is NO DATA in row 12 to 100 the chart shows ZERO. I would like the chart to show NOTHING in that area until data has been added Thanks |
Excel 2007 chart
Exclude that area from your chart so in EXCEL 2007 take the following action:-
- right click on your chart Select Data In here just change the underlying data so that it only places into your chart the data that you want it to include. You can then come back and amend this later as and when you want to add new areas (data) to your chart. If my comments have helped please hit Yes. Thanks. "pcor" wrote: I have a spreadsheet with data in col b starting at row 1 and continuing down to row 10. I want to have a chart depict the values in row 1 to 100 as I will be adding data as time goes by. The trouble that I am having is that although there is NO DATA in row 12 to 100 the chart shows ZERO. I would like the chart to show NOTHING in that area until data has been added Thanks |
All times are GMT +1. The time now is 07:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com