Range, formulas will show the series' data, only if the check box Instead of using the original data range to create the chart, formulas are used toĬreate a duplicate range, linked to the original data. In this example, the original data for the Microsoft Excel chart is in cells B2:H5 Who creates time-saving Excel charting utilities. Note: This tutorial is based on a technique that I learned from Jon Peltier, People can click the check boxes, to quickly show or hide region data in the interactive chart. It works best for small to mid-sized tables. There is no programming required for this technique, and
The graph will then appear on your worksheet.More Chart Tutorials Show Chart Series With Check BoxesĪdd check boxes on a worksheet, to control which series will be shown Select all the cells you have entered data into, including your header.Ĭlick the "Insert" tab, click "Scatter" in the Charts area and then click the type of graph you need.
As you do this, the column will automatically populate with the solutions to each function, based on the value of x in column A. Make sure each of your x values has a corresponding function to the right of it. Select cell B2 and then drag to copy the formula down the column with the same method you used in step 2. Replace "50" with your sale price and "3500" with your costs. For example, to determine the number of sales you need to make of a certain product to cover costs, you could use: Type an equal sign "=" into cell B2 and then type your formula directly after it, without leaving a space. Select both of these cells and then click and drag the small black square in the lower-right corner of the selection area downwards until you have as many values as you want to plot. For example, if your intervals are whole numbers, you might start by entering "1" into cell A2 and "2" into cell A3. Enter the first and second interval of your input variable (for example, "x" or "sales"), which you'll use to plot the function.
0 kommentar(er)
