This is not a specific question about a program bug but more getting ideas on
a design question. I have to produce a Gantt chart type form which has to be
an .MDE file. I actually have a Microsoft Graph working in a prototype. My
problem is I need to be able to set the display range using X axis Max and
Min values by entering them on the form, and also update values in a table
and see the results on the Stacked Bar Chart. Not sure if an .MDE can do
this.

Options seem to be to use a stacked bar chart, use the line function to
create a chart with the timescale calculated through labels, or something I
have not thought of yet. I have spent many hours browsing the net to find an
answer but still not clear on the way forward.

The experience of some people who have been down this path would be
appreciated.

Also would like to get a book on Microsoft Chart/Graph but have not been
able to find a good book on the subject. Anyone have a good reference?

Neville,
I developed an apoplication where I have a horizontal bar chart (Budget,
Fcst, Implemented) and a bar chart representing monthly Budget and
Implemented benfits plus a cummulative line for budget and another for
implemented.
To do this I created the charts from scratch, including autosizing of the
scales.
The code is long and complex but if you send me your e-mail address to
(E-Mail Removed), I can sent the code and screenshots to you.

"NevilleT" wrote:

> This is not a specific question about a program bug but more getting ideas on
> a design question. I have to produce a Gantt chart type form which has to be
> an .MDE file. I actually have a Microsoft Graph working in a prototype. My
> problem is I need to be able to set the display range using X axis Max and
> Min values by entering them on the form, and also update values in a table
> and see the results on the Stacked Bar Chart. Not sure if an .MDE can do
> this.
>
> Options seem to be to use a stacked bar chart, use the line function to
> create a chart with the timescale calculated through labels, or something I
> have not thought of yet. I have spent many hours browsing the net to find an
> answer but still not clear on the way forward.
>
> The experience of some people who have been down this path would be
> appreciated.
>
> Also would like to get a book on Microsoft Chart/Graph but have not been
> able to find a good book on the subject. Anyone have a good reference?