DColin
asked on
Listing chart plot points horizontaly
Hi Experts,
Please see the attached chart.
I am presented data in the form of the first table (Input Limits) and I want to plot this data as shown in the chart.
To do this the data has to be converted into the plot points in the second table (x and y values).
Is there a way of writing a formula that would create this second table from the first? Or...
I know how to create the required plot points and list them horizontally next to the associated data (Input Limits) as in the third table but then the chart can not plot them. Is there a way to get this chart to plot with the plot points listed horizontally?
Thanks.
chart.xlsx
Please see the attached chart.
I am presented data in the form of the first table (Input Limits) and I want to plot this data as shown in the chart.
To do this the data has to be converted into the plot points in the second table (x and y values).
Is there a way of writing a formula that would create this second table from the first? Or...
I know how to create the required plot points and list them horizontally next to the associated data (Input Limits) as in the third table but then the chart can not plot them. Is there a way to get this chart to plot with the plot points listed horizontally?
Thanks.
chart.xlsx
Hello,
it's not quite clear how much you want to automate. In the attached file you can find a grid that translates the data from the Input Limits (which I've transformed into an Excel Table with Insert > Table) to a grid that is used as the chart source.
You can add a new row of data to the Input Limits table. If you want to include that in the chart, copy the block of five rows and paste below. Specify which row of the Input Limits table to plot. Then update the data source for the chart to include the new rows.
See attached file.
cheers, teylyn
chart.xlsx
it's not quite clear how much you want to automate. In the attached file you can find a grid that translates the data from the Input Limits (which I've transformed into an Excel Table with Insert > Table) to a grid that is used as the chart source.
You can add a new row of data to the Input Limits table. If you want to include that in the chart, copy the block of five rows and paste below. Specify which row of the Input Limits table to plot. Then update the data source for the chart to include the new rows.
See attached file.
cheers, teylyn
chart.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To avoid deleting the #NA# cells,
Paste the formula in A8
Pull it to B8
Select A8:B8
Pull it down to B12
Select A8:B13
Pull it all the way down.
Paste the formula in A8
Pull it to B8
Select A8:B8
Pull it down to B12
Select A8:B13
Pull it all the way down.
http://www.pcreview.co.uk/threads/can-excel-draw-a-shape-based-on-values-entered-in-cells.1778032/