Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 28th 05, 11:50 AM
Hoochi Coochi Man
 
Posts: n/a
Default Ploting data with a large range including negative numbers

Hi

I am trying to plot a scatter chart with percentage growth as the y axis.
The range of growths runs from negative to plus several thousand. I would
like to use a log scale but clearly this will not cope with negatives. Any
ideas would be gratefully received!
Many thanks
Keith

  #2   Report Post  
Old April 28th 05, 03:18 PM
bj
 
Posts: n/a
Default

You could separate the positive and negative data and plot the absolute
values of the negative vales in a different color

"Hoochi Coochi Man" wrote:

Hi

I am trying to plot a scatter chart with percentage growth as the y axis.
The range of growths runs from negative to plus several thousand. I would
like to use a log scale but clearly this will not cope with negatives. Any
ideas would be gratefully received!
Many thanks
Keith



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
Setting source data range with Charts D Charts and Charting in Excel 2 January 1st 06 02:51 AM
data range properties baz Excel Discussion (Misc queries) 0 April 1st 05 08:53 AM
How do I count data in range A:A that is dependent upon criteria . h2ocats Excel Worksheet Functions 1 February 21st 05 12:55 PM
Conditional data validation (using a filtered range?) Simon Excel Worksheet Functions 0 February 15th 05 02:39 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 10:55 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017