Area Graphs

[Alex]

Is there a way of stopping area graphs from dropping off
to zero after the last plotted information. For example,
if the last plot at 'X' was 10, then 'X+1' would plot as
zero. I want it to stop at 10. Any ideas.

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to Alex.
Please use the newsgroup for further discussion.]

Use a dynamic chart. See the tutorial on the subject on my web site.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions