Hi,

A hopefully simple question that I could not find an answer for in FP or the docs.

I have a VBAR graph with 2 series. Series 0 should be bars, series 1 a line. All shows OK EXCEPT for the series 1, which instead of showing just the line shows bars as well.

Code:

  
SET GRMERGE=ON

GRAPH FILE TESTFILE
SUM    RUNTIME AS ''  TOT.RUNTIME AS ''
ACROSS SCHEDDATE AS ''
BY GROUP1 

ON GRAPH SET LOOKGRAPH VBAR 
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRWIDTH 0
ON GRAPH SET HAXIS 1200
ON GRAPH SET VAXIS 640
ON GRAPH SET GRAPHSTYLE *

setAxisAssignment(0,0);
setAxisAssignment(1,0);
setSeriesType(1,2);
setPlace(true);
ENDSTYLE
...

Any ideas on how to keep the line for series 1 while removing its bars?

This message has been edited. Last edited by: Microfich,

You have WebFOCUS 762.
That is already equipped with the Advanced Graph Assistant.
You can do this very easily with that tool. Per series you can indicate what type of graph it should be, it works! Check out this tool, I have learned a lot about graphing using it.

quote:

ply

Unfortunately, AGA is not properly installed. Admin is on it but I have to code graphs by hand.

Shouldn't setSeriesType(1,2) take care of it? What am I missing?

Ok, bad enough that you don't have AGA. So I have create a small example where I plot the dcost and rcost from the car file in one graph. One bar, one line. The code is:

GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.BODY.BODYTYPE
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPlace(true);
setSeriesType(getSeries(0),2);
ENDSTYLE
END

Hope this helps ...

Still not working.

It's the ACROSS that's screwing things up.

Guess you right. If I try to do that with the car file (by country across car) I end up with just as many series as there are car brands. You just can't create a line for that. Is there some possibility that you can do it without across?

I'll keep thrashing at it.

C'mon GRAPH experts!

I think if you:

• turn that ACROSS into a BY, and
  
• use GRAXIS 2,

Then you'll actually get two distinct series along the same axis and you'd be able to specify their types (using the advanced graph variant of course) as mentioned by others.

I'm still fairly new to WebFOCUS, but in my experience it's often easier to graph a result if the different graph components each have their own column than to try to combine multiple graphs into a multigraph.

I try to avoid ACROSS in graphs, as it doesn't really add anything and turns graphs into a nightmare (See my thread: Graphing problem with double across for X-axis (Updated))!

Multiple BY's are much easier to deal with IMHO.