Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting source data range with Charts | Charts and Charting in Excel | |||
data range properties | Excel Discussion (Misc queries) | |||
How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
Conditional data validation (using a filtered range?) | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |