Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 08-21-2006, 12:26 PM
Rmaisone Rmaisone is offline
Don't count 0 in a chart
Join Date: Aug 2006
Posts: 1
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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:37 AM.

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