miiorewx.blogg.se

1. #Openoffice conditional formatting more than three how to#
2. #Openoffice conditional formatting more than three series#

It would therefore make better sense to display it as a different chart type with its own Y-axis.Ĩ On the Design tab, in the Type group, click Change Chart Type.ĩ In the Change Chart Type dialog box, click the Combo chart type on the left.īy changing to the combo chart type, Excel changes the second half of the data series to the line type. This new row of data represents an expense, unlike the other data series which represent income. In this exercise, you will modify a chart as a combo chart and use a secondary Y-axis.ġ Ensure the Sales by Type and Year – (your name) workbook is open.Ģ Click in a blank area of the chart to select it.ģ On the Design tab, in the Data group, click Select Data.Ĥ In the Select Data Source dialog box, click Add.ĥ In the Edit Series dialog box, click in the Series name text box, then click cell A16.Ħ Delete the current contents of the Series values text box, then select cells B16 to J16, then click OK.ħ In the Select Data Source dialog box, click OK. The Marketing Department manager for Tolano Adventures has been reviewing her sales data for the past several years, looking for a pattern. Note that you must select one of the data series – four resize handles will appear around each of the data bars in the series. To switch to the other axis, select the Secondary Axis option from the Series Options in the Formatting Data Series pane. To change these chart type and secondary axis options, click Change Chart Type on the Design tab, in the Type group:Īn alternative method of shifting a data series to the secondary axis is to right-click on one of the data points (or bar), and click Format Data Series from the shortcut menu.

You can then combine the combo chart with dual axes so that one chart type uses the primary axis, and the other chart type matches to the secondary axis. You can also select more than two chart types but the chart will look too complex. This is known as a combo chart, in which some of the data series use one chart type (for example clustered column) while the rest of the data series use a different chart type (such as a line). In many cases, you may want to configure the chart using two different chart types at the same time. If you displayed the price data using the primary axis, each data point will be very low compared to sales data and therefore not appear to be meaningful. The price data may use the secondary axis on the right with the scale reaching up to $10.00. The sales volume may use the primary axis on the left with the scale reaching up to 1,000,000 units. An example is a chart that shows data containing prices and sales volume. The primary reason for having two axes is that the chart may have two types of data, each needing its own scale. You can also add an optional secondary Y-axis on the right side. The Y-axis is always displayed on the left side of the chart. The screen should look similar to the following example:ġ0 Save the workbook and leave it open for the next exercise. Remove this row so that the other data columns are easier to see.ħ On the Design tab, in the Data group, click Select Data.Ĩ In the Select Data Source dialog box, scroll down to the bottom of the Legend Entries (Series) list. It is skewing the chart by creating the very tall columns. The chart includes the Total row because it was directly below the rest of the data. Switch the data so that the years are displayed on the horizontal X-axis.ĥ Under Chart Tools, on the Design tab, in the Data group, click Switch Row/Column.Ħ Select the Chart Title label, and change the label to: Sales by Type and Year. Also add a chart title.ģ Click and drag the chart to a new location on the worksheet with the upper left corner in cell A17.Ĥ Click and drag the bottom right corner handle down to cell L40. Move the chart so that it is below the data and make it bigger.

#Openoffice conditional formatting more than three how to#

This exercise is a refresher on how to create a chart, move and resize it, and perform some common customizations.ġ Open the Sales by Type and Year workbook and save as Sales by Type and Year – (your name).Ĭreate a chart using the data in this worksheet.Ģ Click any cell in the range A5:J14, then on the Insert tab, in the Charts group, click Insert Column Chart.Ĭlick Clustered Column in the 2-D Column section. Each of these options commonly uses a pre-selected mix of titles, legend, and other chart formatting settings. The Chart Tools group of tabs includes a wide variety of options you can use to customize the appearance of your chart.īecause there are so many combinations to choose from, you may want to start with one of the selections under the Chart Layouts group in the Chart Tools/Design tab. The Excel charting feature is an extremely powerful tool that displays your data in a visual manner.