1

How is possible to draw in MS Excel (starting from 2003) charts like this

enter image description here

Seems incredible that basic things like this be hard to do in Excel

I read this article but it involves other 2 helper columns of data... I need to have only one data column as source... (and maybe does not work in excel-2003)

  • User the excel camera tool. See ablebits.com/office-addins-blog/2014/07/09/… – DavidPostill Jul 5 '15 at 14:10
  • ...out of excel 2003? – Serge Jul 5 '15 at 14:34
  • 2
    This is an XY scatter graph. – wbeard52 Jul 5 '15 at 17:09
  • Agree with @wbeard52. The important part is getting the order of points correct because Excel will connect them in the order they are shown. Getting the labels down the side is harder. It can be done with some help from a dummy series with data labels. See: stackoverflow.com/questions/30300014/… – Byron Wall Jul 6 '15 at 15:03
  • the scatter graph is horizontal, not vertical – Serge Jul 7 '15 at 9:04
0

A little finicky, but if your data (or more importantly, you vertical category labels) are relatively stable, this works:

  1. Setup you data as:

    |alpha| 3|1|
    |beta |-5|2|
    |gamma| 8|3|
    |zeta |-1|4|
    
  2. Create a scatter plot with the second two columns. You should now have the line in the shape you want.

  3. Copy the first two columns, select the chart, and use Paste Special to add cells as a "New Series".
  4. Now you'll have a second line, rotated. Right click on the new series, and "Change Series Chart Type" to Bar (horizontal bars).
  5. In the Ribbon, under Chart Tools->Layout->Axes select Secondary Vertical Axis->Show Default Axis.
  6. Format the bar chart series to have No Fill and No Border Line to make them invisible.
  7. Format the Primary Vertical Axis and adjust the Min to 0.5. You may have to fiddle with Min/Max, and unit size to get things to line up.
  8. Set Axis Labels to "None" to remove the irrelevant numerical vertical labels.
  9. Optionally remove the duplicate horizontal axis.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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