| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need secondary axis scaling to be inline with primary
Have primary axis scaling in hours, have secondary scale showing $. They are
not very proportionate and both have negatives, but need the zero indicator on both to be in line since the chart is a bar chart. Is this possible without adjusting the scale by hand to make them line up? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need secondary axis scaling to be inline with primary
By hand or with a macro:
http://peltiertech.com/Excel/Charts/AlignXon2Ys.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "colin919" wrote in message ... Have primary axis scaling in hours, have secondary scale showing $. They are not very proportionate and both have negatives, but need the zero indicator on both to be in line since the chart is a bar chart. Is this possible without adjusting the scale by hand to make them line up? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Excel Discussion (Misc queries) | |||
| How to place a secondary y axis bar in a bar chart next to two primary y axis bars? | Charts and Charting in Excel | |||
| Can you link primary and secondary axis zero, scaling? | Charts and Charting in Excel | |||
| Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Linear Mode
