I'm trying to come to grips with converting one of my Access 2002
applications to Access 2010 and have encountered a problem with graphs.
When I opened an existing graph in the converted accdb, I noticed that it
was still showing as a 'MSGraph Chart 8'.
So, I thought I'd need to rebuild it for the newer version. But I opened a
new form and inserted a new Chart, it still came up as a 'MSGraph Chart 8'.
Surely MS has developed its charts beyond that level, but if so, how do I
find and use it?
If I open a chart in access 2010, it seems to be a different version.

An unrelated (I think) issue is when I open the existing graphs in a Windows
7 OS, the graph's formatting is changed. The title label is no longer
centered at the top of the graph, and the chart object is shrunk to about
2/3 size within its form. The same applies to the report version.

Has anyone else experienced these problems?

--
Bob Darlington
Brisbane

My earlier post should have read:
If I open a chart in EXCEL 2010, it seems to be a different version
not
If I open a chart in access 2010, it seems to be a different version
--
Bob Darlington
Brisbane
"Bob Darlington" <bob (AT) notheredpcman (DOT) com.au> wrote

Hi Bob,

I dont know if this is true or not as I dont have Access 2010 (yet!).
What I have been led to believe is that the graphing and charting in
A2010 is now based on the Excel 2010 graph/chart object. This would be
a difference from before where MS Graph was used instead. There are
definitely behavioural differences between the Excel chart object and
MS Graph which may be a cause of the differences you are seeing. I
know that even between versions of Excel you can have differences in
behaviour with supposedly the same chart object model (I build wizards
to make XL do graphs it wasnt intended to for my co-workers). Are you
able to clarify which object model you are actually accessing with
your code - ie/ walk it through line by line and watch the object
creation and chaeck the types etc...?

Cheers

The Frog

"The Frog" <mr.frog.to.you (AT) googlemail (DOT) com> wrote

In Access 2010, if I open a new form and insert a new chart object using the
chart tool from the ribbon, I get an MSGraph8 object.
ie Property Sheet - Data - Class = MSGraph.Chart.8
This seems to be the default object being used by Access 2010.

--
Bob Darlington
Brisbane

Hi Bob,

This is most definitely bizarre behaviour. I do know that the graph
and chart objects that MS provides are shall we say 'not entirely
stable'. With one of the charting tools I made I was having issues
between seemingly identical machines. In the end the only way I was
able to stomp the bugs out was to walk the code each watch each step
perform its function. I discovered that the order of functions, though
seemingly irrelevant in some instances, actually plays a role in the
overall output. That was the case with the two seemingly identical
machines.

What I typically do to get a graph / chart working now is:
1) create object (or reference to it)
2) clean out all data
3) set 'base' graph type
4) add data
5) If needed add secondary data and chart type
6) If needed add secondary axes
7) scale the axes (ie/ set the upper / lower limits, crossover points)
8) expand the legend to some ridiculuous large size (all legend keys
then fit)
9) wipe out any legend keys that arent wanted (eg/ for data series
that are non primary, or used just for adding label points)
10) shrink legend back to original size
11) shrink plot area if needed (when adding large font labels for
example)
12) Add title if needed
13) Add axis labels if needed
14) cleanup objects and references

Following this approach I have managed to get things pretty stable
between versions of Excel / MS Graph (application depending). I must
also add that even after several years of stable operation I still
come across 'new' bugs in the behaviour of the graphing and charting
objects that seem to have absolutely no basis in logic. I dont know if
this is helpful to your current predicament but I thought it worth
mentioning.

Cheers

The Frog

"The Frog" <mr.frog.to.you (AT) googlemail (DOT) com> wrote

Thanks for your response.
Following a 'think' I had at 3am this morning, I found and included a
reference to 'Microsoft Graph 14.0 Object Library' and I can now create a
graph in a 'non MS Graph 8' format. There was previously (Access 2002) no
need to set a reference to Graph 8, so I presume that the object library was
wrapped up in something else.

I still can't figure out the formatting problem with Windows 7 though.
--
Bob Darlington
Brisbane