| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
scale a single series (divide each datapoint by X)
='sheet1'!$BT$63:$CA$63
I have single series in a group that has large values compared to the others contained in the same chart. I would like to scale this single series; divide each point by 10. Was looking for an array function to do this but couldn't figure it out. Thank you. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
scale a single series (divide each datapoint by X)
Insert a row, use formulas in the inserted row to compute the new
values, and chart the inserted row. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ cate wrote: ='sheet1'!$BT$63:$CA$63 I have single series in a group that has large values compared to the others contained in the same chart. I would like to scale this single series; divide each point by 10. Was looking for an array function to do this but couldn't figure it out. Thank you. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
scale a single series (divide each datapoint by X)
On Nov 30, 8:37*am, Jon Peltier wrote:
Insert a row, use formulas in the inserted row to compute the new values, and chart the inserted row. I thought that might be required. Thank you Jon. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to divide a data series into different ranges? | Charts and Charting in Excel | |||
| How do I divide a single image into the slices of a pie chart? | Charts and Charting in Excel | |||
| Displaying single and multiple data series.Single data series | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| Can a Timeline be put to scale (15,000 yr datapoint spread)? | Excel Discussion (Misc queries) | |||
Linear Mode
