| 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 | |||
Linear Mode
