Combo (Bar and Line) in Time Series
If you are a registered user, you can click on the Edit Graph button to open the TechGraph Editor showing the data and settings of this sample chart. You can review and edit the data and settings to learn about the features and capabilities of the application. Shown below are the steps in the Data Table and in the Edit Chart used to create this chart.
Data Table
- Graph Type is “Combo”.
- X Data Type is “Time Series” (M/D/Y) format.
- Graph A has the “Positive” data.
- Graph B has the “7 Day Average” data.
- In this example, a CSV (comma-separated values) file that contains 626 lines of data record was uploaded into the Data Table. Each line contains values for the “M/D/Y” entry, the “Positive” entry and the “7-Day Average” entry. Click on Upload on Edit Data toolbar and select CSV/Text command to upload a CSV file from your local storage.
- The data for this graph could have originated from an external spreadsheet (Excel or Google Sheets). You can copy the data from the spreadsheet to the clipboard and then paste them into Data Table.
Edit Chart
Settings
- Click on Legend Text for Graph A and B. Enter “Positive” in Graph A legend. Enter “7 Day Average” in Graph B legend.
- Click on Graph Type for Graph A. Select “Bar” from Graph Type list.
- Click on Graph Style for Graph A. Set the Color and Pattern for Bar A.
- Click on Graph Type for Graph B. Select “Line” from Graph Type list.
- Click on Graph Style for Graph B. Set the Color, Thickness, and Type for Line B.
- Click on Frame Style/Bkgrd. Select “None” from the Frame Format list.
X Axis Settings
- Click on X Data Type. Set Data Type to Time Series. Select “M/D/Y” from Time Series. Enter “0.1” in Numeric Bar Width to get very thin bars.
- Click on Axis Label. Select “Diagonal” from Justify list for X Axis Label.
- Enter appropriate time series values for Minimum, Maximum, Major Div, Minimum Start, and Maximum End. Leave these values empty for automatic scaling.
Y Axis Settings
- Enter appropriate values for Minimum, Maximum, Major Div, Minimum Start, and Maximum End. Leave these values empty for automatic scaling.
- Click on Major Grid. Check Grid On. Select “2–Line Type” from the Line Type list.
Change Y Axis Label Position
- Select the Left Y Axis Label once the chart is displayed on the Edit Chart Tab. Click on the center “bubble” and hold the left mouse button to move the Left Y Axis Label inside the chart frame.
Add a Logo
- Click on the Image button on the Edit Chart Tab. Select a logo file from your local drive and place it at a desired location on your chart.
Edit Chart Toolbar Options
- Print Chart prints your chart.
- Download Image downloads your chart as an SVG(Scalable Vector Graphics) file or image file(PNG, JPEG, TIF, PDF).
- Drawing Objects customize your chart with labels, lines, arrows, circles, images, and logos.
Getting Started:
- Data Table, Fill Data, Data Transform, Linear Curve Fitter, Nonlinear Curve Fitter
- Edit Chart, Drawing Objects, Chart Setup
- Titles, Settings, X Axis, Y Axis, Curves and Error Bars