#CREATE LINE CHART IN EXCEL FOR MAC PLUS#
#CREATE LINE CHART IN EXCEL FOR MAC SERIES#

#CREATE LINE CHART IN EXCEL FOR MAC PLUS#

Remember to remove the secondary vertical and horizontal axes вЂ“ click on the plus icon next to the chart, and deselect the secondary axis items.

If so, you can just edit the minimum and maximum values of the axis to match the dummy values that you have set in the вЂAverage_yвЂ™ column. Sometimes, if you have a long comment, you can split it into different row lines also. In Excel, you can write text in a any worksheet cell, and it can span into many lines.

One more step though may be needed! Excel may add a bit of extra length to the secondary y axis, so your average line isnвЂ™t quite matching the height of the chart. Microsoft Excel has the capability to read and create CSV files easily.

Click OK and the average line will now be vertical across the chart.

Add the (real) average values into the x field, and the (dummy) вЂAverage_yвЂ™ values into the y field.

#CREATE LINE CHART IN EXCEL FOR MAC SERIES#

Select the вЂAverageвЂ™ dataset, and in the pop-up youвЂ™ll see there are fields for series name, x values and y values.Right-click on the line вЂ“ you will now edit the data values to make the line display as a vertical line across the chart.The average values will now be displayed as a short horizontal line. From the Chart type dropdown next to the Average series name, select вЂ Scatter with straight linesвЂ.Click on one of the bars for the average values, and right-click.The bars for the average values will be added to the chart.In the left hand pane (Legend Entries (Series)), click on the AddВ icon, and in the popup window, select the column header of your helper column, for the series name, and the column of values for the series values.Click on the chart to select it, and from the Design tab, click on the вЂ Select DataвЂ icon.(вЂAverage_yвЂ™ in the example on the right) вЂ“ these will be used later as the вЂyвЂ™ values for your line, and enable the line to be drawn vertically. Switch to the Insert tab and then click the Waterfall Chart button.

Select all the cells, including the row that contains the names and the column that contains the assessment titles. Add a set of вЂdummyвЂ™ values in the next column In this first example, we will create a Radar Chart that shows the assessment of all three trainers.The average values will later be used as the вЂxвЂ™ values for your line. Calculate the average and add the values to the column next to your chart values.

Create line chart in excel for mac