I have a graph showing # of requests on left (indicated by bars in the plot
area), $$ value on right (indicated by line in plot area). I have also
included the data table to show the exact numbers that are plotted. My
question is how to add a third line -- % of Total Requests -- to the data
table without actually plotting the data?

--
martymi

Couple ways:

Plot the data, but format the series to be invisible (no lines, markers,
fill, whatever).

Make a custom table in the worksheet that shows what you want, formatted the
way you want, and don't use the chart's built-in data table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"martymi" wrote in message
...
I have a graph showing # of requests on left (indicated by bars in the plot
area), $$ value on right (indicated by line in plot area). I have also
included the data table to show the exact numbers that are plotted. My
question is how to add a third line -- % of Total Requests -- to the data
table without actually plotting the data?

--
martymi