LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 13th 12, 01:07 PM posted to microsoft.public.excel.newusers
external usenet poster
First recorded activity by ExcelBanter: Dec 2009
Posts: 77
Default Chart Question


Using Excel 2007.

Have a column that I pre-formated with consecutive dates running downwards.

Occasionally, next to some date, there is some data.
I chart this data.

On the data page, I would like to coalese and remove the rows that have
a date, but No data for them (leaving the chart, and future chart
updating) unchanged.

How can I remove these "non-data" lines please, without messing anything
else up ?


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
Pie Chart Question Bill Charts and Charting in Excel 3 March 8th 09 06:41 AM
Chart Question WhytheQ Excel Programming 2 February 16th 08 03:08 PM
chart question Doug W Excel Discussion (Misc queries) 1 January 25th 07 05:16 AM
3d chart question [email protected] Charts and Charting in Excel 2 December 22nd 06 09:32 AM
Chart VBA Question Barb Reinhardt Excel Programming 7 January 14th 06 02:26 PM

All times are GMT +1. The time now is 01:29 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017