Simple Chart

[barbola]

I have a really simple query:

MonthEnd
DataType
PercentDiff

There are two lines on my graph - one for each DataType.

I created a query and ran a PivotChart view and formatted it all pretty but it prints really ugly.

I then noticed I can insert a Chart into a report, so I tried it this way but can't find anyway to format my fonts or dates (shows 7/31/08 instead of Jul-08). Fonts are all big and ugly, percents are showing as .40 instead of 40% even though my query is formatted.

Any help is appreciated. I have never enjoyed creating charts and graphs.

thanks.

 

[pdldavis]

Sometimes all you need to do is force a refresh on your chart:

In Detail Format of your report:

Dim objChart As Object
Dim objGraphApp As Object
Set objChart = Me.YourChartName.Object
Set objGraphApp = objChart.Application

objGraphApp.Update
objChart.Refresh

 

[barbola]

That's not quite what I am looking for. It made no difference in the font sizes or line colours or headings, etc etc.

I decided to go with a query. My form now runs the query in PivotChart format. My only issue now is it prints really big and I want the user to be able to print it a size smaller but I don't want the user to have full menu access, but they can't seem to set any print options.

Any new ideas?

 

[pdldavis]

If you have the chart in a report, go to design view and double-click on the chart and you should be presented with formatting options up top. Right-Click on an item in the chart area to format a specific object. Size the report by dragging the chart.

 

[barbola]

Thanks that's exactly what I was looking for.