**Who can edit a chart?**

- Any Chart Administrators
- Any of the chart’s Owners

**How do I edit a chart?**

- Open any chart in KaiNexus.
- Click in the action bar.

On the resulting screen, make sure you’re in the “Data” tab.**If you want to switch the horizontal axis between date and category, click next to “Date” or “Category,” then choose the option you prefer.**

**If you want to add a new series, click .**

In the resulting window:

- Enter a title.
- (**Optional**) Enter a description.
- Choose whether the series will be displayed as a line or bar.
**Pro Tip: The same Chart can have data series of both types.**

If you chose a line graph, you will be asked if you want to show or hide the markers. If you choose "show," each data point will be marked with a small dot on the chart.

- Choose which vertical axis the series will follow. The left and right axes can be scaled differently. This is useful if, for example, you want to create a Pareto Chart - a bar Chart with a cumulative percentage line. The bar(s) can be assigned to one axis and the line assigned to the other.
- You can have calculated data series that automatically draw from existing data series to fill in the correct information. The calculated series can be a sum, difference, average, percent, or percent change.

In the “Operator” drop-down field, choose which operator the calculated series should use. Depending on which you pick, various new fields will appear.

If you chose:

- Sum: Enter each series you want added together in the “Series” field.
- Difference: Enter the series you want to subtract from in the “Series to subtract from” field and the series you want to subtract from the “Series to subtract” field.
- Average: Enter each series you want to be included in the average in the “Series” field.
- Percent: Enter the series you want as the numerator in the “Numerator Series” field and the series you want as the denominator in the “Denominator Series” field.
- Percent Change: Enter the series you want as the numerator in the “Numerator Series” field and the series you want as the denominator in the “Denominator Series” field.

- Sum: Enter each series you want added together in the “Series” field.
- Choose a color.

You can add as many data series as you want to the Chart – just keep repeating the previous step until you’re satisfied.**Pro Tip: You can click and drag columns into whatever order you want.**You can further customize the chart or make it private by clicking .

In the resulting window, you can:

- Edit the title.

- (**Optional**) Enter a description.

- If your organization has added an Attribute Type to charts, you can pick the correct Attribute.

- Make the chart private so that it is only accessible by members of its team by checking the box next to “Make Private?”

- Give the X-Axis a title that will be displayed below the horizontal axis.
- Give the Left Y-Axis a title that will be displayed alongside the left vertical axis. You can also add a minimum and maximum range.
- Give the Right Y-Axis a title that will be displayed alongside the right vertical axis. You can also add a minimum and maximum range.
- Click .

**You can add lots of rows at once by clicking .**

In the resulting window:

- If you’re working with dates: enter a start date, end date, and step unit (day, week, or month). This will determine how many rows are added.
- If you’re working with categories: enter the number of rows you want to add.

**If you just need to add a single row, click at the bottom of the chart window.**

Rows of dates are automatically arranged in order from oldest to most recent. Rows of categories can be arranged in whatever order you want by dragging and dropping them in the correct position.

**To add or edit data:**

**Add a single data point**: Click on the appropriate column and row intersection, then enter the value.**Copy an entire column of data**from an Excel spreadsheet:

- Go to the spreadsheet containing your data.
- Select an entire column of data - except for any headings. Click "Copy" or hit
*ctrl+c*to copy it. - Go back to the Chart window in KaiNexus and click in the first data box in the corresponding column.
- Either right-click and choose "Paste" or type
*ctrl+v*to paste the data. - Repeat these steps as many times as necessary to copy each column of data into KaiNexus.