Chart X/Y Axis

[stewm]

Hello,

I have a report that has a number of calculations for orders.

Early, Warning, Late are the different order types. So the report looks something like:

Date Early Warning Late
12/13/03 210 10 2
12/14/03 118 3 3
12/15/03 414 16 3

Above this report I want to show a visual with a chart. I put in a chart and it looks like this:

Y Axis, shows 100,200,300,400,500 - OK.

X Axis shows 12/13/03, 12/14/04, 12/15/03. This isn't good because it's a 28 day report. I only want to show every second day in the chart instead. The listframe in the report shows all 28 days. Possible?

Finally, the chart shows a bar for Early, Warning, and Late. I would rather have 1 bar with 3 different colored regions in it. Is this possible?

Thanks, for any chart advice in advance.

Mark



Consultants Club Corp.

 

[AnshuMathur]

Hi Mark

In Charts you can customize the scale for Y-Axis only..
And as for getting Early,Warning and Late in one bar is concerned you can achieve this by checking the percent checkbox under chart properties.That should solve your purpose.

Anshu

 

[stewm]

When I click on the percent box my Y Axis instead of showing 100,200,300,400,500 shows zeros and ones. My X Axis becomes what's in the graph rather then my dates. I figured it would work too but I got strange results when clicking percent.

Consultants Club Corp.