|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 24th, 2010, 02:46 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
do not chart rows with no information
How do I get a chart that does not include rows of data that are empty.
Example: OTD Date Day Abs Acts OT Acts Actuals TP Actuals 02/08/10 Mon 24 0 160 0 02/09/10 Tues 24 1 161 0 02/10/10 Wed 15 1 170 0 02/11/10 Thurs 10 1 175 0 02/12/10 Fri 31 1 153 0 02/13/10 Sat 65 65 0 02/14/10 Sun 02/15/10 Mon 27 0 157 0 02/16/10 Tues 8 1 177 0 02/17/10 Wed 18 1 167 0 02/18/10 Thurs 11 1 174 0 02/19/10 Fri 24 1 161 0 02/20/10 Sat 35 35 0 02/21/10 Sun 02/22/10 Mon 27 0 157 0 I do not want to include any of the "Sun" data in my chart. Thanks, -- clcnewtoaccess 
|
|
#2
February 24th, 2010, 03:51 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
do not chart rows with no information
Hi,
Simplest way is to use Autofilter to hide those rows or just delete them  Either way you will need to change the axis type from Automatic to Category (Text if xl2007) otherwise the Time Serial axis will still include the Sundays. Cheers Andy On 24/02/2010 14:46, clcnewtoaccess wrote: How do I get a chart that does not include rows of data that are empty. Example: OTD Date Day Abs Acts OT Acts Actuals TP Actuals 02/08/10 Mon 24 0 160 0 02/09/10 Tues 24 1 161 0 02/10/10 Wed 15 1 170 0 02/11/10 Thurs 10 1 175 0 02/12/10 Fri 31 1 153 0 02/13/10 Sat 65 65 0 02/14/10 Sun 02/15/10 Mon 27 0 157 0 02/16/10 Tues 8 1 177 0 02/17/10 Wed 18 1 167 0 02/18/10 Thurs 11 1 174 0 02/19/10 Fri 24 1 161 0 02/20/10 Sat 35 35 0 02/21/10 Sun 02/22/10 Mon 27 0 157 0 I do not want to include any of the "Sun" data in my chart. Thanks, -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#3
February 24th, 2010, 04:26 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
do not chart rows with no information
Which type of chart do you have and which version of EXCEL?
Tks. "clcnewtoaccess" wrote: How do I get a chart that does not include rows of data that are empty. Example: OTD Date Day Abs Acts OT Acts Actuals TP Actuals 02/08/10 Mon 24 0 160 0 02/09/10 Tues 24 1 161 0 02/10/10 Wed 15 1 170 0 02/11/10 Thurs 10 1 175 0 02/12/10 Fri 31 1 153 0 02/13/10 Sat 65 65 0 02/14/10 Sun 02/15/10 Mon 27 0 157 0 02/16/10 Tues 8 1 177 0 02/17/10 Wed 18 1 167 0 02/18/10 Thurs 11 1 174 0 02/19/10 Fri 24 1 161 0 02/20/10 Sat 35 35 0 02/21/10 Sun 02/22/10 Mon 27 0 157 0 I do not want to include any of the "Sun" data in my chart. Thanks, -- clcnewtoaccess
|
|
#4
February 24th, 2010, 05:11 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
do not chart rows with no information
First option Column chart.
Microsoft Office Excel 2003. -- clcnewtoaccess "trip_to_tokyo" wrote: Which type of chart do you have and which version of EXCEL? Tks. "clcnewtoaccess" wrote: How do I get a chart that does not include rows of data that are empty. Example: OTD Date Day Abs Acts OT Acts Actuals TP Actuals 02/08/10 Mon 24 0 160 0 02/09/10 Tues 24 1 161 0 02/10/10 Wed 15 1 170 0 02/11/10 Thurs 10 1 175 0 02/12/10 Fri 31 1 153 0 02/13/10 Sat 65 65 0 02/14/10 Sun 02/15/10 Mon 27 0 157 0 02/16/10 Tues 8 1 177 0 02/17/10 Wed 18 1 167 0 02/18/10 Thurs 11 1 174 0 02/19/10 Fri 24 1 161 0 02/20/10 Sat 35 35 0 02/21/10 Sun 02/22/10 Mon 27 0 157 0 I do not want to include any of the "Sun" data in my chart. Thanks, -- clcnewtoaccess
|
|
#5
February 24th, 2010, 05:24 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
do not chart rows with no information
EXCEL 2007
I have just put up a chart for you at:- http://www.pierrefondes.com/ It is item number 72 towards the top of my home page. I think that this gives you what you want. I have hidden rows 8 and 15 to achieve the desired effect. If my comments have helped please hit Yes. Thanks. "clcnewtoaccess" wrote: How do I get a chart that does not include rows of data that are empty. Example: OTD Date Day Abs Acts OT Acts Actuals TP Actuals 02/08/10 Mon 24 0 160 0 02/09/10 Tues 24 1 161 0 02/10/10 Wed 15 1 170 0 02/11/10 Thurs 10 1 175 0 02/12/10 Fri 31 1 153 0 02/13/10 Sat 65 65 0 02/14/10 Sun 02/15/10 Mon 27 0 157 0 02/16/10 Tues 8 1 177 0 02/17/10 Wed 18 1 167 0 02/18/10 Thurs 11 1 174 0 02/19/10 Fri 24 1 161 0 02/20/10 Sat 35 35 0 02/21/10 Sun 02/22/10 Mon 27 0 157 0 I do not want to include any of the "Sun" data in my chart. Thanks, -- clcnewtoaccess
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
