If i understand, the fundraising value is correct, but it just looks small
because the revenue makes the y range very large? If this is the case, you
can look into adding the fundraising range as a secondary y axis that you can
set up how you like. To do this, assuming it is already on your chart, click
the fundraising series, right click and select format data series. Next click
the Axis tab and select secondary axis. If this looks funny you can right
click again and change the chart type. For example if you are doing a bar
chart, change this series to a line chart. If they are all lines, make it
stand out so people know it is on the secondary axis.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"april" wrote:

i have 5 yrs of revenue data. however, 2 of those yrs had significant spikes
because of unusual circumstances. i would like to hihlight this fact - i.e
say that the total revenue for a spike year was $2M, but that $900K was due
to extraordinary circumstances. also i am showing the revenue data and the
fundraising expenses for that same period. because of the spike in revenue,
the fundraising increments aren't dramatic because the scale has been set by
that high revenue number. any suggestions?

thanks
--
aprilshowers