PC Review

Reply

Rate Thread

How do I stop line on chart - Pste-specl-values (BLANKS) in VB

=?Utf-8?B?S29MTSNz?=

Guest

Posts: n/a

30th Jan 2006

When I am using VB with a Button to (copy, paste special-values) blanks, the
chart shows the blanks as zeros unless I manually delete all the blank
cells????

Reply With Quote

Reply

« How to create a z chart in excel ? | How can you add the same data series to all charts in a workbook »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Chart values for blanks show as zero (Excel 2003)	SoccerTedTx@yahoo.com	Microsoft Excel Charting	2	6th Jan 2009 04:26 PM
How to stop Pie Chart from using N/A# for values	Dave	Microsoft Excel Charting	2	13th Mar 2007 05:28 PM
How can I stop a line in the middle of a chart?	=?Utf-8?B?Um9iZXJ0IEJyb3du?=	Microsoft Excel Charting	1	25th Jul 2006 06:53 PM
Skipping Blanks in "Y" Values on Chart	Bill Foley	Microsoft Excel Charting	1	9th Aug 2004 08:58 PM
Line chart zero values	Walshy	Microsoft Excel Charting	4	16th Jun 2004 05:09 PM

Features

Forums Startup Database Reviews Articles FAQ / Guidelines About Us

Advertising

Newsgroups

Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware

All times are GMT +1. The time now is 05:20 PM.