I am trying to create a chart in VFP7 using Excel automation and would like
to chart data on the secondary Z axes but don't have a clue.
I am using the Chart Wizard to create the initial stacked bar chart and
would like to overlay some lines using the secondary axes.
I have created macros in Excel to view and looked at the VB help and can not
figure out how to add a secondary axes and map data to this axes.
Some sample code being used to create the stacked bar:
lnChartType=3 && Column Chart
lnChartFormat=3 && Stacked Bar
lnPlotBy=1 && 1=Data in Rows, 2=Data in Columns
lnCategoryLabels=1 && Indicates how many rows (if plotting by rows) or
columns (if plotting by columns) to use as the labels on the category (X)
axis.
lnSeriesLabels=1 && Indicates how many columns (if plotting by rows) or
rows (if plotting by columns) to use to label the series. Generally, the
labels appear in the legend.
llHasLegend=.T. && Indicates whether the chart has a legend (.T.) or not
(.F.).
lcTitle=lcPassedTitle && A character string used to title the chart. By
default, it is centered just above the plot area.
lcCategoryTitle=lcPassedSubTitle && A character string used to title the
category (X) axis.
lcValueTitle="" && A character string used to title the value (Y) axis.
lcExtraTitle="" && A character string used for a second value axis title
in 2D charts (if two separate value axes are used), or as the series (Z)
axis title in 3D charts.
WITH loChart
.ChartWizard(loSourceRange,lnChartType,lnChartFormat,lnPlotBy,
lnCategoryLabels,lnSeriesLabels,llHasLegend,lcTitle,lcCategoryTitle,lcValueT
itle,lcExtraTitle)
ENDWITH
Thanks in advance
Tim Cairns