How To Make Line Graphs In Excel Smartsheet Highlight both columns of data and click charts > line > and make your selection. we chose line for this example, since we are only working with one data set. excel creates the line graph and displays it in your worksheet. other versions of excel: click the insert tab > line chart > line. Step 3: add chart elements. adding chart elements to your chart or graph will enhance it by clarifying data or providing additional context. you can select a chart element by clicking on the add chart element dropdown menu in the top left hand corner (beneath the home tab). to display or hide axes: select axes.
How To Make Line Graphs In Excel Smartsheet On the right rail, select the icon > chart. or select edit > add widget > chart. before you can select your chart, you must first select your data. select add data in the data & chart type section. on the left side of the form, select the sheet or report that contains the table you want to chart. then select the range of cells on the right side. I would like add a chart to a dashboard showing actual vs forecast revenues per month. i need a combined chart actual revenue shown in bar format and forecast shown in line format. i know you can do this type of chart in excel however i'm struggling in smartsheets i only have the option to have a line or bar chart. Hello, i think i may have found a solution, but it will require a tiny bit of rearranging your data sheet: if you separate the columns by year, then it recognizes that q1 in 2020 should be compared to q1 in 2021. here's the line chart i got from that: hope this helps! best, heather. lashawnta barker . A step by step tutorial on how to build a dashboard in smartsheet from scratch. watch an expert create a dashboard from start to finish in under an hour. wit.
Comments are closed.