When faced with a set of numerical data in excel, the need to display them effectively is almost immediate. however, the wide range of graphics options available in microsoft software can often generate confusion. although there are numerous types of graphics, the key is to select what best represents the relationships and trends in your data. this article will guide you through the choice and creation of different types of graphics, with a particular focus on line charts and their variants, as well as explain how to create a column chart, illustrating the steps both for the desktop version of excel (windows and macos), both for excel online and mobile application.
The line chart: when using it and how to create it #
The line chart is an excellent choice when you want to display the trend of one or more data sets over time or through sorted categories. imagine having a table where the first column contains labels or categories (such as months, years or products) and adjacent columns contain the numerical values corresponding to each label. in this scenario, the line chart is almost always the most appropriate solution, because it allows to clearly highlight trends, peaks and flexions.
Basic features of line chart #
- horizontal axis (x): it hosts data categories or labels (e.g. time, products).
- vertical axis (y): it represents the numerical values associated with each category.
- **representation the data are united by a continuous line, facilitating the perception of evolution.
Data preparation for a line chart #
Before proceeding with the creation, it is essential that the data be arranged correctly. generally, you should have a column for categories (e.g. column a) and one or more columns for numerical values (e.g. column b, c, etc.). it is good practice to also include column headers in the first row, as excel will use them for chart legend.
Create a basic line chart: step by step #
The procedure for inserting a line chart is intuitive and similar on all platforms, with slight differences in the user interface.
On excel desktop (windows and macos): #
- selection of data:* examine the entire range of data you want to include in the chart. this must include the column of categories and all data columns you want to represent, including column titles. you can do this by clicking on the first cell (e.g. a1) and dragging the mouse to the last cell of data (e.g. b10). alternatively, click on the first cell, hold shift/maiusc key on the keyboard and click on the last cell you want.
- insertion of chart: go to the insert** tab in the all-in-one bar.
- type choice: in the graphics* section, look for the icon that represents lines. click on it and, in the opening pane, select one of the line 2d* (avoiding the ‘pilla’ options for a standard line chart).
- recommended transfers (alternative): if you are not sure, you can click recommendedgraphs, move to all graphs** and choose the line chart you want from the list.
- confirm:* click ok. the chart will appear directly on your spreadsheet and you can place it where you prefer.
On excel online: #
The methodology is almost identical to that desktop. after selecting the data, go to the insert* tab and click on the line button.
On the microsoft excel app (android and ios/ipados): #
Through the app, the process is slightly adapted to the mobile interface. select the desired data, then tap the drop down menu (often labeled as ‘home’ or similar) and choose insert. from there, select graph and then line*.
Represent multiple data series: the multiple line chart #
Often the need to compare the trend of multiple variables on the same time or category axis. a multiple-line chart is perfect for this purpose. the principle is the same as the single-line chart, but the amount of drawn lines will depend on the number of numerical data sets you have selected.
How a multiple line chart works #
If, for example, your table has column a for categories, column b for the first set of data and column c for the second set of data, selecting all three columns (a, b and c), excel will automatically generate a graph with two distinct lines. each line will represent the trend of a specific set of data (b or c), using column a as a common reference for the horizontal axis.
The creation procedure does not change compared to the one described for the chart to a line. the only crucial difference lies in the initial selection of data: make sure to highlight all columns containing the numerical values you want to compare, as well as the column of categories.
Improve clarity: line charts with indicators #
For greater visual accuracy and to highlight the exact points of each value, you can choose a line chart with indicators. these indicators are small symbols (such as squares, circles or triangles) placed on each data point along the line.
How to create line charts with indicators #
The steps for creation are identical to those of a standard line chart. the only difference is when selecting the type of chart: when you explore the options in the “lines” section (or “recommended graphics”), choose specifically the variant that includes indicators. it is easily recognizable by a line with small markers visible on each data point.
This option is available for both single and multiple line charts, on all excel platforms. if you have multiple data sets, each line will have its own indicators, keeping clear the distinction between different trends.
Soft lines and continuous trends: the scatter chart with curved lines #
Another very useful type, although less known with its technical name, is the dispersion chart with curved lines. this type of chart is distinguished by traditional line charts because it is not limited to connecting discrete categories on the x axis, but it connects a series of x-y points with a soft and rounded line, without sharp angles. it is particularly suitable when you have to represent data that follows a regular variation, mathematical models or continuous phenomena.
When using a scatter chart with curved lines #
- To show relationships between continuous numerical variables.
- To display fluid or trajectory trends.
- In scientific or engineering contexts for experimental data.
Data preparation and creation #
For this type of chart, the layout of data is crucial: the first column must contain values for the x axis and the second column values for the y axis.
- **selection of data:***examine the two data columns (x and y).
- insertion of chart: in the insert* tab, look for the dispersiongraph icon (often depicted with scattered points).
- choice of variant: from the drop-down menu, select the dispersion with curved lines.
- optional:* you can also choose the dispersion version with curves and indicators if you want to highlight individual data points.
The procedure is the same for excel desktop, online and mobile app (remember that on the app the insert tab is located in the menu below).
Comparison of distinct values: the column chart (or “vertical lines”) #
Many users look for a way to create a “vertical line chart” when, in reality, the most suitable option and the correct term is ** columns graph** (or istogram). this type of chart is extremely effective to compare numerical values between different discrete categories.
Characteristics of column chart #
- Each vertical column represents a specific value for a category.
- The column height is directly proportional to the value it represents.
- Ideal for direct and fast comparisons between non-continuous elements.
How to create a column chart #
Also for column chart, data preparation is standard: one column for categories and one or more for numerical values.
On excel desktop (windows and macos): #
- selection of data:* please note the data columns you want to represent.
- insertion of chart: go to insert*.
- type choice: in the graphics* section, click on the istogram or bar chart icon.
- selection of variant: in the menu, under the section colonne 2d, choose colonne grouped*.
On excel online: #
After selecting the data, go to the insert* tab and click the istogram* button, then choosing the “colonne grouped” variant.
On the microsoft excel app (android and ios/ipados): #
Select the data, then go to insert* -> graph -> colonne and choose the first option in the list.
Customization and finishing of your excel charts #
Once the graph is inserted, excel offers ample customization possibilities to make it lighter, aesthetically pleasing and suitable for your specific needs. whether you’re using the desktop or online version, click on the chart will activate a context card (often called picture**************) from which you can access different options:
- colors:* changes the colors of the elements of the chart, lines or columns.
- legenda:* add, hide or reposition the legend to clearly identify the different data sets.
- data labels: enter numerical values directly on data points or columns for immediate reading.
- title and assi:* customize chart title and axle labels to give context.
- plastic styles:* apply predefined styles for quick change of overall appearance.
It is important to note that excel’s desktop version generally offers a more robust customization feature set than excel online, although both allow essential changes to improve chart readability.
Conclusion #
Mastering the creation of graphs in excel is a fundamental competence for anyone working with data. whether it’s a simple line chart to show time evolution, a multiple line chart for complex comparisons, a scatter chart for smooth trends or a column chart for categorical comparisons, excel provides the tools needed to transform crude numbers into powerful visual narratives. experience the different options and techniques described to find out which fits your viewing and communication needs better.