Microsoft Office Tutorials and References
In Depth Information
Modifying a chart’s data
Fiddling with the base unit value is not the only way to get open-high-low-close charts!
Excel offers four types of stock charts, including open-high-low-close candlesticks.
To see the choices, click the Insert tab on the ribbon and then click Other Charts. The
stock charts, listed in the gallery under the heading Stock, require you to set up your
data in columns—for example, with separate columns for Open, High, Low, and Close.
The methods described in this chapter are useful to know about when your data is not
arrayed as required for the built-in stock chart types.
Modifying a chart’s data
The simplest way to add new data points to an existing series on a chart is to make the
chart’s source range a table (select any cell within the range, and press Ctrl+T; for more
information, see “Creating a table,” in Chapter 22) and then add new rows to the table.
Excel incorporates these rows into the chart without requiring you to do anything further.
If you add a new column immediately to the right of a table, Excel expands the table to
include the column. If you’ve created a chart from such a table, the new column becomes
a new data series. That might or might not be desirable, depending on the contents of the
new column. If you find yourself with an unwanted new series, you can delete it by
selecting the series on the chart and pressing the Delete key. Alternatively, you can use the Filter
button to remove it. (See “Filtering chart data,” later in this chapter.)
Using the mouse to add data points
If you choose not to make your source data a table, you can still use your mouse to add
data points to an existing chart series. Figure 19-7 shows a candlestick chart that plots data
through May 2. Notice that because the chart area is selected, Excel draws two rectangles
around the source data. The first rectangle, in column A, outlines the range that the chart is
using for its category axis labels. The second, encompassing columns B through E, outlines
the four data series. Excel uses magenta for the first rectangle and blue for the second to
help you distinguish between the two.
Search JabSto ::

Custom Search