Waterline on Access Chart

[mclellan]

Hello,

I have a table of values that measure CPU utilization which looks like this: Date, CPU

I also have a MAX CPU table that has a value set at 80.

I would like to be able to plot a graph that shows a single line for my CPU utilization, but also has a waterline set at 80, so that if my graph goes over this mark, it will be obvious.

I can create the graph for the CPU utilization, but I can't figure out how to set a waterline.

Thanks!
Barry

 

[dhookom]

You can add a column to your graph's row source like:

SELECT [Date], [CPU], 80 as MaxCPU
FROM tblYourTable
ORDER BY [Date];

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[mclellan]

Thanks Duane, I didn't realize you could set more than one field in the Sum section on the chart.

Have a great day