Apps for Access

Our implementations of core visualizations are a testbed to learn about how these tools are used with database tools.

We provide core visualizations, familiar to users of Excel and other popular charting tools:

  • A bar chart and column chart. These differ only in the orientation of the bars.
  • A line chart and an area chart; both offer stacked or overlapping areas. An area chart is filled; a line chart only draws the top line.
  • A pie chart
  • A scatter chart, or scatter plot.
For each of these apps, the system expects see one column of X axis labels, and several columns of series data. Press "Generate" to insert sample data on the sheet.
Year Sales  Profit 
2001  100  14 
2002  122  12 
...  ...  ... 

 

Click [Series Data...] to select the series: Sales and Profit.

Click [Label Data...] be used to select the labels: the Year column.

This image shows a column chart for the sample data above.

 

Notes

For the area chart and line chart, the visualization will attempt to interpret the ‘labels’ column as ascending, numeric X axis values. If that works, then it will render them appropriately spaced; the spacing need not be regular. If any of the values are not numeric, or not ascending, then each label will instead be placed as evenly-spaced categories.

Charts behave inconsistently with negative Y-axis values.

Note that in the current version of the charts, the X and Y axes are automaitcal