Using KChart in KSpread
Prev
Next

Chapter 4. Using KChart in KSpread

In addition to standalone operation, KChart is designed to be used with KSpread. This chapter describes how to create and manipulate charts from within KSpread.

Remember that KChart embedding into KSpread is a very commonly used and well implemented feature, the examples in this chapter should just get you started.

As soon as you have created a chart in KSpread you can take full advantage of all the KChart features by double clicking on the chart area. This is necessary to get to all advanced configuration options. Keep in mind that the data editor is not available when KChart is embedded into KSpread. This is obvious since KSpread serves, from KChart's point of view, as a powerful data provider.

Swapping x and y is of particular interest when working with KSpread. You can swap interpretation of x and y axis in KChart in the Data Format settings which can be accessed through the Edit menu or the context menu when right clicking on the chart itself. As noted above you need to be inside the KChart component in order to access these settings, which can be done by double clicking the embedded chart in your spreadsheet.

Plotting with KChart

To plot with KChart, when it is embedded in KSpread, do the following:



  • Highlight the second row of numbers.

  • Next click on the Chart button to create the chart.

  • Select the options you want from the chart wizard. The chart Wizard will pop up after you insert the chart.

The whole data could also be created using two columns instead of two rows. If using columns you might want to switch x and y axis in the KChart configuration as described above.

To make a bar chart for individual items, put the numbers in a column, as shown below.



The orientation of the numbers determines how the plot will be made.

  • A row of numbers defines the ordinates for a single plot.

  • A column of numbers defines the heights for each bar, in a bar graph. It also determines the size of the slices in a pie chart.

Prev
Next
Home


Would you like to comment or contribute an update to this page?
Send feedback to the TDE Development Team