Microsoft Office Forums Don't count 0 in a chart

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2006, 12:26 PM
Rmaisone Rmaisone is offline
Novice
Don't count 0 in a chart
 
Join Date: Aug 2006
Posts: 1
Rmaisone
Default Don't count 0 in a chart


I want a line chart that does'nt pick 0 or a blank cell as a value for example ' I have a chart with values for the whole month (31 days) and I want the line to be from day 1 to 5 (monday thru friday) then leave blank the next 2 days (6 & 7, saturday and sunday) and then start again on days 8 to 12 and so on. When I make the line chart that line goes graphic to 0
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Don't count 0 in a chart Gantt Chart: MS Project vs. Excel Nance Project 2 12-09-2008 01:59 PM
How to count cells containing data and meet certain criteria AdamNT Excel 1 08-11-2006 11:51 PM
Help with a macro to shade a selected pie chart hzrvkt Excel 0 02-24-2006 01:25 PM
Don't count 0 in a chart One bar chart for 3 sets of data rclloyd Excel 1 02-03-2006 09:51 AM
Don't count 0 in a chart Page breaks inserted in Gantt chart have no effect Steve Sells Project 2 11-09-2005 08:12 PM


All times are GMT -7. The time now is 12:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft