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 / July 2009

Tip: Looking for answers? Try searching our database.

empty columns not to be displayed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nikhil - 03 Jul 2009 11:09 GMT
Hi

I have a table that displays data depending upon values that a user selects
from a control box.

Based on these values, a column chart is displayed.

My problem is...depending upon the value that the user selects from the
control box, the no. of columns  of data to be plotted also changes.

If the user selects 1st value, there are 6 columns X 1 row. But if he
selects 2nd value, there are 9 columns X 1 row to be plotted in the graph.

The problem is, in the first case, the graph shows the first six columnar
chart but shows blank (empty column space) for the remaining 3.

Can you help me remove the empty 3 column space when the user selects 1st
value...There is no problem when the user selects the 2nd value.

Regards

Nikhil
Shane Devenshire - 03 Jul 2009 17:41 GMT
Hi,

When you say the user picks from a "control box" what exactly are you using?
If you are using a combo box control then you already have code to display
or hide the items.  Then you would just add code to hide the blank columns -
charts by default plot only visible cells.

Signature

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

> Hi
>
[quoted text clipped - 18 lines]
>
> Nikhil
 
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



©2010 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.