LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 148
Default Excel 2007 chart

I have data in col B row 1 to 10:
I have a chart of this worksheet showing col B row 1 to 1000
Here is the trouble:The chart shows the data in row 1 to 10 but also shows
ZERO's for the remainder of the chart. 9IN DUE TIME THERE WILL BE DATA ALL
THE WAY TO ROW 1000).I would like very much to have the chart show a blank
for any row that contains NO DATA.
Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Excel 2007 chart to Word 2007 - only half of it shows NonTechie Excel Discussion (Misc queries) 2 November 3rd 09 09:26 PM
copying chart from Excel 2007 to Word 2007 NonTechie Charts and Charting in Excel 1 November 1st 09 12:53 PM
Cannot insert Chart in Excel 2007 and all other Office 2007 applications Hii Sing Chung Charts and Charting in Excel 0 July 24th 09 03:53 PM
Pasting a chart from Excel 2007 to Word 2007 trouble Vegas Charts and Charting in Excel 5 September 16th 08 07:37 AM
Chart Selection - Excel 2007 copy to Powerpoint 2007 GS80 Charts and Charting in Excel 1 February 7th 08 01:30 PM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"