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. |
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) |