DPlot

Hi,
I'd like to make a graph using dPlot Jr just like it happens using example.xls -> BarChart -> BarChart(label, Y1, Y2) and so getting label on X axis ... is it possible using dplotlib.dll? If yes, can you give me a hint?
Is it possible to have label on X axis using not barchart but "standard" xyplot?

Thanks and regards,
Max

I'd like to make a graph using dPlot Jr just like it happens using example.xls -> BarChart -> BarChart(label, Y1, Y2) and so getting label on X axis ... is it possible using dplotlib.dll?

Yes. (FYI the Add-In uses DPLOTLIB.DLL, so anything it does you can also do programmatically.)

If yes, can you give me a hint?

The best hint is to take a look at Sub BarChart() in the Add-In to see what it does. In Excel select Tools>Macro>Visual Basic Editor. In the Project pane click on "dplotlib (DPLOTLIB.XLA)". You'll be prompted for a password; use "dplot" without the quotes. Under "dplotlib (DPLOTLIB.XLA)" click the plus sign next to Modules, then double-click "DPlotData" and search for "Sub BarChart".

The numbers on the X axis are turned off with
Labels are added a bit below that line with an XYLabel command:

Is it possible to have label on X axis using not barchart but "standard" xyplot?

Yes, there's no difference. Just use a different ScaleCode. In the BarChart routine you'll notice that the labels are offset from the X value associated with the bar (Str$(k + 0.5)) so that the labels are centered on the bar rather than the left side of the bar. For other scale types you'll probably not want that offset.

Thanks a lot!