Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Syncronise zero values
I have seven columns of data to chart. Columns A & B have values around 500,000 to 600,000 and I wish to show them against the right hand axes as a line chart. The remaining columns have values from -50,000 to +200,000 and I wish to show them against the left hand axes as column chart. Is it possible to get their zero values on the same level? Is this making sense to anyone? Thanks for any help -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=550743 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Syncronise zero values
Thanks very much - you'd think that Bill could code that in quite easily...! -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=550743 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding zero values in charts | Charts and Charting in Excel | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel |