ChartType Forms and Reports

  • Thread starter Thread starter chuck.streb
  • Start date Start date
C

chuck.streb

Because Chart Type literal constants don't work in Access. I haven't
figured out why.
I have been using the numbers associated with the constants.

I have a problem now where the following string works on forms (Example
1
) but not in reports.

Example 1
GraphName.Object.Application.Chart.ApplyCustomType ChartType:=(22),
Name:="name of custom plot"

Example 2
This is what does work in reports. But it does not let me use my custom
graphs.

GraphName.Object.Application.Chart.ApplyCustomType ChartType:=(4)

Does anyone know how to get Example 1 to work in reports???

I think I have hit a dead end.
 
Reports("Printout")!GraphName.Object.Application.Chart.ApplyCustomType
ChartType:=(23), TypeName:="name of custom plot"

TypeName not Name !

Details Details ...

This should be helpful too. Use VBAGR10.CHM for a help file.

Below are the numeric constants for ACCESS

* XlChartGallery

#define xlBuiltIn 21
#define xlUserDefined 22
#define xlAnyGallery 23

XlChartType

#define xlColumnClustered 51
#define xlColumnStacked 52
#define xlColumnStacked100 53
#define xl3DColumnClustered 54
#define xl3DColumnStacked 55
#define xl3DColumnStacked100 56
#define xlBarClustered 57
#define xlBarStacked 58
#define xlBarStacked100 59
#define xl3DBarClustered 60
#define xl3DBarStacked 61
#define xl3DBarStacked100 62
#define xlLineStacked 63
#define xlLineStacked100 64
#define xlLineMarkers 65
#define xlLineMarkersStacked 66
#define xlLineMarkersStacked100 67
#define xlPieOfPie 68
#define xlPieExploded 69
#define xl3DPieExploded 70
#define xlBarOfPie 71
#define xlXYScatterSmooth 72
#define xlXYScatterSmoothNoMarkers 73
#define xlXYScatterLines 74
#define xlXYScatterLinesNoMarkers 75
#define xlAreaStacked 76
#define xlAreaStacked100 77
#define xl3DAreaStacked 78
#define xl3DAreaStacked100 79
#define xlDoughnutExploded 80
#define xlRadarMarkers 81
#define xlRadarFilled 82
#define xlSurface 83
#define xlSurfaceWireframe 84
#define xlSurfaceTopView 85
#define xlSurfaceTopViewWireframe 86
#define xlBubble 15
#define xlBubble3DEffect 87
#define xlStockHLC 88
#define xlStockOHLC 89
#define xlStockVHLC 90
#define xlStockVOHLC 91
#define xlCylinderColClustered 92
#define xlCylinderColStacked 93
#define xlCylinderColStacked100 94
#define xlCylinderBarClustered 95
#define xlCylinderBarStacked 96
#define xlCylinderBarStacked100 97
#define xlCylinderCol 98
#define xlConeColClustered 99
#define xlConeColStacked 100
#define xlConeColStacked100 101
#define xlConeBarClustered 102
#define xlConeBarStacked 103
#define xlConeBarStacked100 104
#define xlConeCol 105
#define xlPyramidColClustered 106
#define xlPyramidColStacked 107
#define xlPyramidColStacked100 108
#define xlPyramidBarClustered 109
#define xlPyramidBarStacked 110
#define xlPyramidBarStacked100 111
#define xlPyramidCol 112
#define xl3DColumn 0xffffeffc
#define xlLine 4
#define xl3DLine 0xffffeffb
#define xl3DPie 0xffffeffa
#define xlPie 5
#define xlXYScatter 0xffffefb7
#define xl3DArea 0xffffeffe
#define xlArea 1
#define xlDoughnut 0xffffefe8
#define xlRadar 0xffffefc9
 
Back
Top