Forum Discussion
i need help with adding a line and a price into this chart of mine.
i want how it has the line and value.
i have a example of what i want and my chart. please help me.
If the line can be in a fixed position and doesn't need to move based on data, then you can select the chart and choose Insert tab of the ribbon > Shapes > Line. Then you can position the line where you want it.
If you need it to be based on data, then you can create a new column of data in your table with the same value in every row. Then go to the chart's Select Data dialog and add a new series to the chart. Set the new column as the data series. Once you have the new series in the chart, select the new series and change the chart type to a line chart. That's what I've done in this example. The values in column D are shown as the orange line in the chart. You may need to adjust the min and max of the vertical axis, like you can see on the right side of my chart. I set it to have a min of 0 and a max of 12.5 to get the orange line to appear where I wanted it.
3 Replies
thank you!
If the line can be in a fixed position and doesn't need to move based on data, then you can select the chart and choose Insert tab of the ribbon > Shapes > Line. Then you can position the line where you want it.
If you need it to be based on data, then you can create a new column of data in your table with the same value in every row. Then go to the chart's Select Data dialog and add a new series to the chart. Set the new column as the data series. Once you have the new series in the chart, select the new series and change the chart type to a line chart. That's what I've done in this example. The values in column D are shown as the orange line in the chart. You may need to adjust the min and max of the vertical axis, like you can see on the right side of my chart. I set it to have a min of 0 and a max of 12.5 to get the orange line to appear where I wanted it.
ok thanks i got it to work.
