Share via

Graph Multiple Lines on a Single Graph Given Two Coordinate Sets

Anonymous
2023-07-21T01:44:13+00:00

I am trying to use the graph function to create a floor plan showing wall locations. See Example data set below. Each wall has a start coordinate and an end coordinate. Is there an easy way to do this? I would like to be able to label each wall on the graph as well.

Wall Label X Start Y Start X End Y End

WP1 56 29 56 35

WP18 55 210 55 220

WP35 .5 90 11 90

WP58 28 36 18 36

I have roughly 200 walls so it will not work to input each manually.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2023-07-21T11:34:45+00:00

    An answer of sorts in the linked-to file below.

    Update the data in the blue table on the left, then right-click somewhere in the green table and choose Refresh. The chart should update itself. Stretch the chart vertically if you want to make it more proportional.

    File: https://app.box.com/s/apnp0l954c2f6l39eac2uz8e5231yl43

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-21T23:47:48+00:00

    This was perfect, thank you!

    0 comments
  2. Anonymous
    2023-07-21T07:19:09+00:00

    Could you share us a test workbook without sensitive information in it? Then we may help you create such graph.

    For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

    Based on your data, I guess you want to show all the wall in one chart. You should create two table, one for Horizontal and another for Vertical.

    After that, you can combine them.

    0 comments