Re: OWC Chart: How to combine bar and line graf programatically?
From: Hans Riis (hri_at_bang-olufsen.dk)
Date: 05/05/04
- Next message: Sbarrier: "Office 2K3 Toolpack"
- Previous message: Hans Riis: "Re: OWC Chart: How to combine bar and line graf?"
- In reply to: Hans Riis: "Re: OWC Chart: How to combine bar and line graf programatically?"
- Messages sorted by: [ date ] [ thread ]
Date: 5 May 2004 00:38:53 -0700
Hi, I'm sorry for the confusion. I changed the title of my response
without knowing it would start a new thread. The original question
was:
I'm trying to create a bar chart with one series of data and
another series of data represented as a line.
I get my data from MS SQL.
I create the chart in Frontpage and add dropdown menus with JavaScript
calls
to control the chart component for people with little IT
understanding.
For this first chart I'm looking for a way to combine bars and lines
using the same scale (in another chart I'll need to have separate
axes). I Haven't gotten as far as the combo part yet.
I hope somebody can help me out!
This bit of JavaScript code works for just changing one measure on the
y-axis:
function Sel_Field()
{
c=ChartSpace1.Constants;
ChartSpace1.PlotAllAggregates = 1;
ChartSpace1.HasPlotDetails = true;
ChartSpace1.PlotAllAggregates = c.chPlotAggregatesSeries;
ChartSpace1.SetData(c.chDimValues, c.chDataBound, "");
ChartSpace1.SetData(c.chDimValues, c.chDataBound, "BarVar");
}
This doesn't work as a replacement of the last line above:
ChartSpace1.SetData(c.chDimValues, c.chDataBound,
Array("BarVar","LineVar"));
I also tried VBScript but that didn't help much:
<SCRIPT language=VBScript
set c=ChartSpace1.Constants
ChartSpace1.PlotAllAggregates = 1;
ChartSpace1.HasPlotDetails = true;
ChartSpace1.PlotAllAggregates = c.chPlotAggregatesSeries
ChartSpace1.SetData c.chDimValues, c.chDataBound, ""
ChartSpace1.SetData c.chDimValues, c.chDataBound,
Array("BarVar","LineVar")
</SCRIPT
Thanks in advance, Hans Riis (Denmark)
- Next message: Sbarrier: "Office 2K3 Toolpack"
- Previous message: Hans Riis: "Re: OWC Chart: How to combine bar and line graf?"
- In reply to: Hans Riis: "Re: OWC Chart: How to combine bar and line graf programatically?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
