graph
By |Published On: August 12, 2021 at 10:41 am PDT|Last Updated: January 27, 2022 at 6:17 pm PST|

Top and Bottom Combo (Bar/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 and Graph B has the “7 Day Average” data for the Bottom Graph.
  • Graph C has the “Death” data and Graph D has the “7 Day Average” data for the Top Graph.
  • 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 for the Bottom Graph, and the “Death” entry and the “7-Day” Average for the Top Graph. 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 C. Enter “Positive” in Graph A legend. Enter “Death” in Graph C legend.
  • Click on Legend Text for Graph B and D. Uncheck Show Legend to suppress legend for graph B and D.
  • Click on Graph Type for Graph A. Select “Bar” from Graph Type list. Click on Graph Style for Graph A. Select Color and Pattern for Graph A. Repeat this step for Graph C.
  • Click on Graph Type for Graph B. Select “Line” from Graph Type list. Click on Graph Style for Graph B. Select Color, Thickness, and Type for Line B. Repeat this step for Graph D.
  • Click on Frame Style/Bkgrd. Select “None” from Frame Format list.

     X Axis

  • Click on X Data Type. Set Data Type to “Time Series”. Select “M/D/Y” from the Time Series list. Enter “0.1” in Numeric Bar Width to get very thin bars.
  • Click on Axis Label. Select  “Sideways” from the 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.

    Curves and Error Bars

  • Select “Right Y” from the Left/Right Y Axis list for Graph C and D.

     Left Y Axis for the Bottom Graph

  • Click on the Y Axis. Select “Left Y” in the Axis Selection list.
  • Set the maximum value to leave room for the Top Graph. For example, enter “60000” in Maximum when the maximum value for the data set is 30000. The graph will appear on the lower half of the frame.
  • Set Minimum Start and Maximum End so that the Y Axis Labels appear on the lower half of the frame.
  • Click on Major Grid. Set Grid On. Select “2-Line Type” from the Line Type list.

    Right Y Axis for the Top Graph

  • Click on the Y Axis. Select “Right Y” in the Axis Selection list.
  • Set the minimum value to leave room for the Bottom Graph. For example, enter “-4000” in Minimum when the maximum value for the data set is 4000. The graph will appear on the upper half of the frame.
  • Set Minimum Start and Maximum End so that the Right Y Axis Labels appear on the upper half of the frame.
  • Click on Major Grid. Set 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.
  • Select the Right Y Axis Label. Click on the center “bubble” and hold the left mouse button to move the Right Axis Label inside the chart frame.

     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: