ProductsXMLSpyXML Charts

XMLSpy® 2012 makes it incredibly easy to create eye-catching, impactful charts for displaying XML data. Now you can visualize, analyze, and report numerical XML and XBRL data directly inside XMLSpy with just a few clicks.

Chart creation in XMLSpy® 2012 brings a whole new dimension to working with, communicating, and reporting XML data. It's no longer necessary to export XML in a different format, or to another application, in order to create an attractive, dynamic chart to immediately communicate data results and relationships. Once you've specified the data and appearance of your graph, XMLSpy offers various one click options for sharing it: printing, copying to the clipboard, saving as an image file, or even exporting it as XSLT or XQuery code for easy re-use.

Creating an XML Chart

When working with XML data in XMLSpy, you can simply highlight a context node or a range of data that you'd like to display and analyze, and XMLSpy will render it in an attractive, highly customizable chart or graph. Charts can then be printed or exported for use in other applications. The following chart types are supported:

• Pie charts (2D & 3D)
• Bar charts & stacked bar charts (2D & 3D)
• Category & value line graphs
• Area charts & stacked area charts
• Gauge charts
• Candlestick charts

To build a chart or graph, highlight the required range of data in XML Text View or XML Grid View, right click, and select New Chart. The Select Columns dialog opens, allowing you to specifiy the data for the X axis and Y axis. The Source XPath is automatically entered based on your cursor position or highlighted data range. Alternatively, you can enter the XPath manually to specify the data you want to graph.

Once your data is selected, the Select Data dialog lets you further configure your chart series, axis values, and so on.

Next, you can select the type of chart or graph that best suits your XML data.

The Chart Appearance dialog allows granular customization of the chart's appearance, including:

• Chart title and legend
• Chart color scheme
• Axis labels and positions
• Text fonts, sizes, and colors
• Background images
• Background colors and color gradients
• Tick intervals and grid lines
• And more

Nine separate tabs in the Charts Output Window allow you to create and store different charts as you work. Below is a custom bar chart displaying temperature data.

The chart display is dynamic based on the underlying XML data. If you've selected Auto Reload, your chart will be updated on the fly as XML values change. Alternatively, you can turn off Auto to manually regenerate your chart with the Reload button. In the example below, the data for February has changed, and the chart reflects that instantly.

Chart Overlays

The Overlays feature lets you combine multiple charts in a single image. Each overlay chart has unique settings and can even be generated from a separate data file. The image below shows a candlestick chart of a stock’s daily prices with the daily sales volume in a bar chart overlay.

Saving and Exporting XML Charts

Once you are satisfied with the appearance of your chart, there are several options available for exporting it to the clipboard, an image file, or as XSLT or XQuery code, as shown below. Charts may also be printed directly from XMLSpy.

Exporting the chart as XSLT or XQuery allows you to use it in your own stylesheet or application to generate the chart based on dynamic XML data. The XSLT/XQuery code can be executed in XMLSpy and via AltovaXML Reporting Edition, an XML standards processor available for use in your applications.

Charting Profiler Results

XMLSpy® 2012 also supports chart creation for results data delivered by the XSLT profiler and XQuery profiler. After profiling an XSLT or XQuery execution, one click creates a chart to help you immediately visualize the results based on one or more criteria.

This makes it easy to immediately interpret the results of a profiling an XSLT or XQuery execution or to communicate those results with other team members in a powerful, visual way.

Experience easy chart creation in XMLSpy to display, analyze, and report your XML data like never before.

 Click here to download a fully functional, free 30-day trial of Altova XMLSpy!