Cyclones Posted March 26, 2008 Share Posted March 26, 2008 So I'm doing a combo bar/line graph and want to put a target line on the graph. How does one go about doing this? Quote Link to comment Share on other sites More sharing options...
Zooty Posted March 26, 2008 Share Posted March 26, 2008 I use the "drawing" tool to make a line. But I'm sure there is a way to insert one, I've just never found it Quote Link to comment Share on other sites More sharing options...
bushwacked Posted March 26, 2008 Share Posted March 26, 2008 I'm guessing you could designate a secondary y-axis and put in target lines, but Zooty's idea might be less painful. Quote Link to comment Share on other sites More sharing options...
SuperBalla Posted March 26, 2008 Share Posted March 26, 2008 Ask yer sexretary to help you. Quote Link to comment Share on other sites More sharing options...
Big Country Posted March 26, 2008 Share Posted March 26, 2008 I think this is what you are looking for Quote Link to comment Share on other sites More sharing options...
bushwacked Posted March 26, 2008 Share Posted March 26, 2008 I think this is what you are looking for The method involves adding a new series, applying it to the secondary axes, and making the secondary axes disappear Quote Link to comment Share on other sites More sharing options...
Cyclones Posted March 26, 2008 Author Share Posted March 26, 2008 I think this is what you are looking for Okay, I officially hate Excel now. I can't believe there is not a target value option. Ridiculous. Quote Link to comment Share on other sites More sharing options...
bushwacked Posted March 26, 2008 Share Posted March 26, 2008 Okay, I officially hate Excel now. I can't believe there is not a target value option. Ridiculous. What you are trying to do is actually pretty easy once you have a template. PM me if you want. I can e-mail you something. Quote Link to comment Share on other sites More sharing options...
Ursa Majoris Posted March 26, 2008 Share Posted March 26, 2008 Okay, I officially hate Excel now. I can't believe there is not a target value option. Ridiculous. +1. I've been searching off and on for the ability to draw a target line based on a single value on a bar chart for ages. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.