如果想两条数据显示在一起例如
汇总输入如下
想实现如下效果
根据机器+优先级分类
形成一个图标
根据分类分别显示 额定工时+占用工时
大概实现向这一这个图形
后来不感觉上面数据可能不照(有可能高手能实现 我是菜鸟)
转为下面的数据
分开数据如下
红色部分是实际占用工时,黑色为额定工时
再次实现如上显示
依旧不照,应该是设置有问题
还望大侠们给予指点迷津
------解决方案--------------------
release 8;
datawindow(units=0 timer_interval=0 color=1090519039 processing=3 HTMLDW=no print.documentname="" print.orientation = 1 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=0 color="536870912" )
table(column=(type=number updatewhereclause=no name=核算年 dbname="name_1" )
column=(type=number updatewhereclause=no name=核算月 dbname="name_2" )
column=(type=char(10) updatewhereclause=no name=机器名称 dbname="name_3" )
column=(type=number updatewhereclause=no name=优先级 dbname="name_4" )
column=(type=number updatewhereclause=no name=数量 dbname="name_5" )
column=(type=char(10) updatewhereclause=no name=类型 dbname="name_6" )
)
data( 2010, 4,"机器1", 1, 480,"实际", 2010, 4,"机器1", 1, 899,"额定", 2010, 4,"机器1", 4, 600,"实际", 2010, 4,"机器2", 4, 899,"额定",)
graph(band=background height="316" width="2857" graphtype="7" perspective="2" rotation="-20" color="0" backcolor="16777215" shadecolor="-6795776" range= 0 border="3" overlappercent="0" spacing="100" elevation="20" depth="100"x="0" y="0" height="316" width="2857" name=gr_1 visible="1" sizetodisplay=1 series="类型" category="机器名称+'优先级:'+string(优先级)" values="sum(数量 for graph)" title="额定工时+占用工时" title.dispattr.backcolor="553648127" title.dispattr.alignment="2" title.dispattr.autosize="1" title.dispattr.font.charset="0" title.dispattr.font.escapement="0" title.dispattr.font.face="Arial" title.dispattr.font.family="2" title.dispattr.font.height="0" title.dispattr.font.italic="0" title.dispattr.font.orientation="0" title.dispattr.font.pitch="2" title.dispattr.font.strikethrough="0" title.dispattr.font.underline="0" title.dispattr.font.weight="700" title.dispattr.format="[general]" title.dispattr.textcolor="0" title.dispattr.displayexpression="title" legend="4" legend.dispattr.backcolor="536870912" legend.dispattr.alignment="0" legend.dispattr.autosize="1" legend.dispattr.font.charset="0" legend.dispattr.font.escapement="0" legend.dispattr.font.face="Arial" legend.dispattr.font.family="2" legend.dispattr.font.height="0" legend.dispattr.font.italic="0" legend.dispattr.font.orientation="0" legend.dispattr.font.pitch="2" legend.dispattr.font.strikethrough="0" legend.dispattr.font.underline="0" legend.dispattr.font.weight="400" legend.dispattr.format="[general]" legend.dispattr.textcolor="0" legend.dispattr.displayexpression="series"
series.autoscale="1"
series.displayeverynlabels="0" series.droplines="1" series.frame="1" series.label="类型" series.majordivisions="0" series.majorgridline="1" series.majortic="3" series.maximumvalue="0" series.minimumvalue="0" series.minordivisions="0" series.minorgridline="1" series.minortic="1" series.originline="1" series.primaryline="0" series.roundto="0" series.roundtounit="0" series.scaletype="1" series.scalevalue="1" series.secondaryline="0" series.shadebackedge="0" series.dispattr.backcolor="536870912" series.dispattr.alignment="0" series.dispattr.autosize="1" series.dispattr.font.charset="0" series.dispattr.font.escapement="7" series.dispattr.font.face="Arial" series.dispattr.font.family="2" series.dispattr.font.height="0" series.dispattr.font.italic="0" series.dispattr.font.orientation="0" series.dispattr.font.pitch="2" series.dispattr.font.strikethrough="0" series.dispattr.font.underline="0" series.dispattr.font.weight="400" series.dispattr.format="8" series.dispattr.textcolor="0" series.dispattr.displayexpression=" title " series.labeldispattr.backcolor="553648127" series.labeldispattr.alignment="2" series.labeldispattr.autosize="1" series.labeldispattr.font.charset="0" series.labeldispattr.font.escapement="0" series.labeldispattr.font.face="Arial" series.labeldispattr.font.family="2" series.labeldispattr.font.height="0" series.labeldispattr.font.italic="0" series.labeldispattr.font.orientation="0" series.labeldispattr.font.pitch="2" series.labeldispattr.font.strikethrough="0" series.labeldispattr.font.underline="0" series.labeldispattr.font.weight="400" series.labeldispattr.format="[general]" series.labeldispattr.textcolor="0" series.labeldispattr.displayexpression="''" series.sort="1"