#DBVISUALIZER ALTERNATIVE SERIES#

This is the chart after applying category and 2 series:ДЄ chart can be displayed as Line, Point, Area, Stacked Area, Bar, Stacked Bar and the Pie type.

#DBVISUALIZER ALTERNATIVE SERIES#

Tip: Press the ALT key while selecting a serie and all currently selected series will be de-selected. To changeВ categoryВ column click the category drop-down and pick what column to use. In the following example it is the datelabelВ and idВ columns for this specific result set. When switching to the chart view DbVisualizer automatically pick the first date or text column as category and the first numeric column as serie. To activate the chart view click the rightmost button in the result tab toolbar: The normal output view of a result set in the SQL Commander or Monitor window is in a grid style as shown in the following screenshot.

Further refinement of the chart can be made in the chart preferences window.

Just select one or more columns that should appear as series in the chart and what column to use as the category (X-axis). The basic setup of a chart is really easy. Charts are configured and viewed in the SQL CommanderВ and in the MonitorВ tool which isВ really powerful, delivering real time charts of many result sets simultaneously. Charts may be exported as an image to file, printed and copied to system clipboard for easy sharing with other tools. It offers much of the charting support you find in MS Excel and other specialized charting tools. The chart support in DbVisualizer presents data from any result set in a configurable chart displayed in a line, bar, area or pie style.

Dbvisualizer alternative