How to Create Charts

[chasmith17]

Hello,
I need to know how to create a chart that has more than 6 fields. In the chart wizard it will not let me pick more than 6 fields per chart. When I look up help it talks about using global charts but I can't find out how to select global charts. I have a chart already made in Excel can I import that? If not I need to make a graph for this. Thanks for your help.

Gun I Targ I Gun V Bmag V RF DRV PFN V
18x -1.28 2.13 -6.58 54.79 19.54 52.84
6x -2.67 59.07 -16.13 17.4 24.3 40.2
6e -0.99 0.11 -5.07 19.98 20.86 43.68
9e -0.99 0.11 -5.07 28.42 21.72 43.78
12e -0.11 0.11 -5.07 38.5 24.98 43.58
16e -0.7 0.11 -3.12 50.45 12.32 52.6
20e -0.7 0.11 -3.12 68.67 25.17 52.43

 

[lbass]

What version of CR are you using? In your chart above, we can't tell what the fields used are. It looks like the leftmost column might be one field with values 18x, 6x,6e, etc. Are the columns separate fields with the results shown in the matrix? If so, you would just use col1 as your on change of field, and then add each of the other six fields as your summary fields.

-LB

 

[chasmith17]

LB, thanks for your reply. The top row where I have GUN I, Targ I, Gun V, Bmag V, RF Drv, and PFN V are test points where I make measurments. Then where I have 18X, 6X, 6E etc. is the different energies that have the same test points. So what I am doing is taking a measurement for the test points for all energies. Hope this is clear. What I am trying to do is super easy in EXCEL and I could just stick with that but the rest of my work is in an Access DB.

 

[chasmith17]

Okay so I just realized I am in the wrong Forum. Sorry for the confusion. I need to be in the Access forum.