Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to combine xyline plot with bar plot in excel. I created xyline plot and then added new series with a hope that I can chance the series 1 later.

Step 1: But it turned to be not true, see the results. Particularly misalignment of the axis. created xy line plot:

enter image description here

Step 2: Added line series 2, then changed back the series 1 to bar.

enter image description here

But it turned to be bad:

enter image description here

Any resolution? I need to do this excel, I am using 2007 version. Scripts to fix such problem are welcome.

share|improve this question

migrated from stackoverflow.com Mar 20 '13 at 3:00

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 3 down vote accepted

A column chart has a Category X axis, not a value X axis. If you want the columns placed according to their numeric value, then you can use Error Bars.

Create error bars with the "Minus" option, no caps and 100% error. Then format the line color and thickness. (see screenshot). Then remove the actual series line (I've left it faintly visible in the screenshot)

enter image description here

share|improve this answer
    
thanks, What do you mean by XY chart ? XY (Scatter , or line) ? I really want series 1 to be bar - thus line plot overlayed over bar, but the matter is fit of the plot. –  jon Mar 18 '13 at 20:02
    
Sorry, I misunderstood the question. I've edited the answer. –  teylyn Mar 18 '13 at 20:20
    
You really shouldn't use a smoothed line. In this case particularly, your data points represent binned counts (whole numbers), so it would be useful to use markers as well as straight lines. otherwise, it gives the impression that you have a smooth albeit wavy distribution. Also smoothed lines make it look like the red distribution dips below zero, which is silly. –  Jon Peltier Apr 2 '13 at 12:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.