I am trying to draw walls in a building that the user inputs. The only way I can think to do this is with a scatter plot with each wall being its own series so that each wall can have its own trendline and data label. For now, the user can input 125 walls. I'd rather not take the time to build 125 different series and 125 different trendlines/data labels. What's the easiest way to do this?
I really only need to do it once to set up the chart. From there, the chart should update as the user updates the data without the need for a macro to be running.
Right now, my x coordinates are in two columns, and my y coordinates are in two columns.
I really only need to do it once to set up the chart. From there, the chart should update as the user updates the data without the need for a macro to be running.
Right now, my x coordinates are in two columns, and my y coordinates are in two columns.
