Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
kelp
 
Posts: n/a
Default Squiggly line to show more dramatic results?


If you will refer to my screenshot, I'd like to make the graph appear
more dramatic. The y values on the left go from 0-30,000. Is there
anyway to make the y values skip a few thousand and scaling it so it
looks more dramatic?


+-------------------------------------------------------------------+
|Filename: excel.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4465 |
+-------------------------------------------------------------------+

--
kelp
------------------------------------------------------------------------
kelp's Profile: http://www.excelforum.com/member.php...o&userid=32506
View this thread: http://www.excelforum.com/showthread...hreadid=522933

  #2   Report Post  
Posted to microsoft.public.excel.newusers
systemx
 
Posts: n/a
Default Squiggly line to show more dramatic results?


Hi,

If you select the chart, then select the axis you want to adjust, you
can then right-click and select 'Format Axis'. You will find a 'Scale'
tab where you can set minimum and maximum values, or change the scale.

The easiest thing for you to do would change the the minimum number of
fatalities...so the chart occupies space on the entire axis.

Hope this helps

Rob


--
systemx
------------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254
View this thread: http://www.excelforum.com/showthread...hreadid=522933

  #3   Report Post  
Posted to microsoft.public.excel.newusers
kelp
 
Posts: n/a
Default Squiggly line to show more dramatic results?


That's perfect. Just in time, too. Thank you very much.


--
kelp
------------------------------------------------------------------------
kelp's Profile: http://www.excelforum.com/member.php...o&userid=32506
View this thread: http://www.excelforum.com/showthread...hreadid=522933

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
show results of two pivot charts johnjmcdermott Charts and Charting in Excel 3 March 6th 06 12:47 PM
How do I configure excel to show results when highlighting cells? Saulo Excel Discussion (Misc queries) 4 February 16th 06 12:08 AM
Cannot get border line on right of table to show. Debutante Excel Worksheet Functions 1 January 21st 05 05:17 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 08:48 PM
show if more than one line of data jenn Excel Worksheet Functions 1 December 20th 04 11:45 PM


All times are GMT +1. The time now is 03:56 PM.

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

About Us

"It's about Microsoft Excel"