Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel - Conditional Function for Graphs
- Thread starter Sepie
- Start date
What you would need to do is separate the positive and negative values into two columns. Plot the data. Make negative values column the secondary axis, make the scales of the two axes equal and then format the secondary axis to make it disappear.
"10 kinds of people in the world. Those who understand binary numbers and those who don't."
"10 kinds of people in the world. Those who understand binary numbers and those who don't."
- Status