#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 111
Default graphs

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 772
Default graphs

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default graphs

I would be tempted to plot two lines on the chart. Line one would show the
actuals, and line two would show the actuals minus the unusual amounts. This
addresses your first concern, which is to show that some amounts are
exaggerated. Your second concern may be addressed through the use of either
a log scale axis, which would confound most non-scientists, or a broken
value axis, which is easier to read but harder to set up. Here's a tutorial:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

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


"april" wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP WITH GRAPHS Buggy Excel Discussion (Misc queries) 0 July 13th 06 08:41 PM
Having to re-do graphs galatea2153 Charts and Charting in Excel 4 April 16th 06 11:05 AM
Are there better GRAPHS within EXCEL or Add-on graphs? Deb Charts and Charting in Excel 1 February 1st 06 02:19 PM
Automatic Graphs/ Dynamic Graphs DanielWalters6 Charts and Charting in Excel 1 January 24th 06 10:29 PM
Line Graphs and Bar Graphs Christopher Anderson Excel Discussion (Misc queries) 1 December 3rd 04 07:16 PM


All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"