Automatic Charting Problems

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

Hello,

Please bare with me as I try to explain my report &
problem.

I have a report, that has several rows of values that need
to be charted out. To avoid the hassle & headache of
having one million charts to see, I have set up a look up
table which the user can select up to 5 rows of values to
chart out on one chart.

In order for this to work, my chart has to be set on those
5 lookup rows. But incases where the user will only want
to chart out one row, the chart still is showing the other
rows that do not have information in them.

Now assuming I havn't lost you yet, are they any kind of
tricks that I can do with charts, so that it will not show
empty series even though it is included?

If it's easier, I can send out the actual file to anyone
who feel they'd be able to help me, or suggest other ways
around this problem.

Thank you,
Jay Gustafson
 
Jon,

Thank you for answering my post and giving me that link. Since my post, a
user of this forum has solved my problem via e-mail. But I will keep this
link for future reference.

Thank you :)
Jay Gustafson
 
Back
Top