Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / August 2008

Tip: Looking for answers? Try searching our database.

Chart for hidden rows?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FARAZ QURESHI - 11 Mar 2008 06:42 GMT
I am feeling some trouble!

I have a Bar Graph based on a data table based on Subtotals & Grouping!
Whenever the first level of Grand Total is selected the chart's bars vanish!

Any idea how to overcome this problem.

Thanx in advance!

Signature


Best Regards,
FARAZ A. QURESHI

Andy Pope - 11 Mar 2008 09:41 GMT
Hi,

Select the chart and then use the menus
Tools > Options > Chart
Uncheck 'Plot visible cells only'

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>I am feeling some trouble!
>
[quoted text clipped - 5 lines]
>
> Thanx in advance!
GSalisbury - 11 Mar 2008 13:52 GMT
> Hi,
>
[quoted text clipped - 4 lines]
> Cheers
> Andy

Thank you - I, too, had a chart using what would ordinarily have been a
hidden column.
I'm new to charting so, not stopping to look, took the "easier?" way out -
white font color and shrunken column width.
This is much better.
Geo. S.
dobie - 20 Aug 2008 00:57 GMT
I have rows not showing in a spread sheet.  I tried the HELP suggestion, same
as yours (TOOLS, OPTIONS) but the "Plot visible cells only" check box isn't
checked.  Where are my missing rows?  How do I find them?
Signature

dobiegillis

> Hi,
>
[quoted text clipped - 14 lines]
> >
> > Thanx in advance!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.