Graphs within different formats

[nonskanse]

Hi! I would like to display 2 graphs in a report, and have the graphs re-occur on each change in a certiain field (a city in this case).

City1
Graph1 Graph2
Data............
Graph3

City2
Graph1 Graph2
Data............
Graph3

etc.
I would like to do this in excel. Any clues are appreciated!!!

-nonskanse

 

[gizzy17]

I wasn't able to do it in Excel but I did do it in html --

SET GRAPHSERVURL = '[URL unfurl="true"]http://uecker/ibi_apps/IBIGraphServlet'[/URL]
FILEDEF G1 DISK C:\IBI\DEVSTUDIO52\IBI_HTML\G1.GIF
FILEDEF G2 DISK C:\IBI\DEVSTUDIO52\IBI_HTML\G2.GIF
FILEDEF G3 DISK C:\IBI\DEVSTUDIO52\IBI_HTML\G3.GIF
FILEDEF G4 DISK C:\IBI\DEVSTUDIO52\IBI_HTML\G4.GIF
-RUN
-*GOTO HERE
GRAPH FILE CAR
SUM RETAIL_COST
ACROSS MODEL
WHERE COUNTRY EQ 'ENGLAND'
ON GRAPH HOLD AS G1 FORMAT GIF
END
GRAPH FILE CAR
SUM DEALER_COST
ACROSS MODEL
WHERE COUNTRY EQ 'ENGLAND'
ON GRAPH HOLD AS G2 FORMAT GIF
END
GRAPH FILE CAR
SUM RETAIL_COST
ACROSS MODEL
WHERE COUNTRY EQ 'ITALY'
ON GRAPH HOLD AS G3 FORMAT GIF
END
GRAPH FILE CAR
SUM DEALER_COST
ACROSS MODEL
WHERE COUNTRY EQ 'ITALY'
ON GRAPH HOLD AS G4 FORMAT GIF
END
-RUN
-HERE
DEFINE FILE CAR
IMG/A10 = '<' | 'IMG ';
END
TABLE FILE CAR
BY COUNTRY
WHERE COUNTRY EQ 'ENGLAND' OR 'ITALY'
ON COUNTRY SUBFOOT
&quot;<IMG SRC='[URL unfurl="true"]http://localhost/ibi_html/g1.gif'>[/URL]  <IMG SRC='[URL unfurl="true"]http://localhost/ibi_html/g2.gif'>&quot;[/URL]
WHEN COUNTRY EQ 'ENGLAND'
ON COUNTRY SUBFOOT
&quot;<IMG SRC='[URL unfurl="true"]http://localhost/ibi_html/g3.gif'>[/URL]  <IMG SRC='[URL unfurl="true"]http://localhost/ibi_html/g4.gif'>&quot;[/URL]
WHEN COUNTRY EQ 'ITALY'
END

 

[nonskanse]

That's cool for html, but I need excel. Thanks though! I will keep trying.