ALV bar chart

[Former Member]

Hi all,

i was trying to display bar chart for my alv report and i need some value as axis

[Former Member]

Hi all,

i was trying to display bar chart for my alv report and i need some value as axis

[Former Member]

hi George

why don't u gone through the demo program BARCBO01.

[Former Member]

example:-

REPORT  ZGRAPHS_3D.




TYPES: BEGIN OF ttab_data,
        dataname(15),
        quantity1 TYPE i,
        quantity2 TYPE i,
        quantity3 TYPE i,
       END OF ttab_data.

TYPES: BEGIN OF ttab_options,
        option(20),
       END OF ttab_options.

DATA: itab_data TYPE TABLE OF ttab_data,
      xtab_data LIKE LINE OF itab_data.

DATA: itab_options TYPE TABLE OF ttab_options,
      xtab_options LIKE LINE OF itab_options.

xtab_data-dataname = 'Screws'.
xtab_data-quantity1 = 5500.
xtab_data-quantity2 = 6200.
xtab_data-quantity3 = 5900.
APPEND xtab_data TO itab_data.

xtab_data-dataname = 'Nails'.
xtab_data-quantity1 = 3500.
xtab_data-quantity2 = 5200.
xtab_data-quantity3 = 4400.
APPEND xtab_data TO itab_data.

xtab_data-dataname = 'Nuts'.
xtab_data-quantity1 = 1800.
xtab_data-quantity2 = 2200.
xtab_data-quantity3 = 1900.
APPEND xtab_data TO itab_data.

xtab_data-dataname = 'Fastners'.
xtab_data-quantity1 = 5500.
xtab_data-quantity2 = 6200.
xtab_data-quantity3 = 5900.
APPEND xtab_data TO itab_data.

xtab_data-dataname = 'Bolts'.
xtab_data-quantity1 = 3500.
xtab_data-quantity2 = 5200.
xtab_data-quantity3 = 4400.
APPEND xtab_data TO itab_data.

xtab_data-dataname = 'Clamps'.
xtab_data-quantity1 = 1800.
xtab_data-quantity2 = 2200.
xtab_data-quantity3 = 1900.
APPEND xtab_data TO itab_data.

xtab_data-dataname = 'Hand Tools'.
xtab_data-quantity1 = 5500.
xtab_data-quantity2 = 6200.
xtab_data-quantity3 = 5900.
APPEND xtab_data TO itab_data.

xtab_data-dataname = 'Saws'.
xtab_data-quantity1 = 3500.
xtab_data-quantity2 = 5200.
xtab_data-quantity3 = 4400.
APPEND xtab_data TO itab_data.

xtab_data-dataname = 'Jigs'.
xtab_data-quantity1 = 1800.
xtab_data-quantity2 = 2200.
xtab_data-quantity3 = 1900.
APPEND xtab_data TO itab_data.


CALL FUNCTION 'GRAPH_MATRIX_3D'
  EXPORTING
    titl = 'Usage in $'
    col1 = 'Materials'
  TABLES
    data = itab_data
    opts = itab_options.

[Former Member]

hi

use fm GRAPH_MATRIX_3D

assign some fncode for graph button and call the fn module when user click that button.

DATA: BEGIN OF ITAB_DATA OCCURS 0,

DATANAME(15),

QTY1 TYPE I,

QTY2 TYPE I,

END OF ITAB_DATA.

Data: BEGIN OF ITAB_OPTIONS OCCURS 0,

OPTION(20),

END OF ITAB_OPTIONS.

ITAB_DATA-DATANAME = 'Bolts'.

ITAB_DATA-QTY1 = 500.

ITAB_DATA-QTY2 = 600.

APPEND ITAB_DATA.

like that add the data in itab_data.

CALL FUNCTION 'GRAPH_MATRIX_3D'

EXPORTING

COL1 = 'Jan'

COL2 = 'Feb'

COL3 = 'Mar'

TITL = 'Quantity chart for quarter'

TABLES

DATA = ITAB_DATA

OPTS = ITAB_OPTIONS

EXCEPTIONS

OTHERS = 1.

regards

Nishant Malhotra