To add a vertical line to an Excel line chart, carry out these steps: Select your source data and make a line graph ( Inset tab > Chats group > Line ). Set up the data for the vertical line in this way: In one cell (E1), type the text label for the data point at which you... In one cell (E1), type. Here you have a data table with monthly sales quantity and you need to create a line chart and insert a vertical line in it. Please follow these steps. Enter a new column beside your quantity column and name it Ver Line. Now enter a value 100 for Jan in Ver Line column How to add a vertical line to the chart 1. Add the date with the current date to your data, for example:. 2. To add a new data series to your chart, do one of the following:. 3. If it is necessary, change data series:. 4. On the Design tab, in the Chart Layouts group, click the Add Chart Element. Add Vertical Line using Shapes. The easiest way to add vertical line to Excel chart is to draw a line on top of the Excel Chart using shapes. Follow the steps on how to add a vertical line in Excel graph below: STEP 1: Select the data that will be used to create a chart. STEP 2: Go to Insert > Line Charts > Line with Markers

- Right click the new line and choose Change Series Chart Type. 7. In the Change Chart Type dialog box, select Combo section under All Charts tab. Then select Scatter with Straight Lines and check the option for Secondary Axis
- I want to have a line chart that shows the sales in different months on the timeline and mark the maximum value by adding a vertical line. Follow the steps below: 1: Add a support column to Identify the max number. To insert a vertical line on the max point, we need a supporting column that identifies the max value. Insert a column in the table. And insert this formula to identify the max value
- Add vertical line to bar chart Now you need to insert a bar chart first. 1. Select your data range, and click Insert > Bar > Bar
- Add a Vertical Line to a Column or Line Chart: Series Method. How do you add a nice vertical line to a column or line chart, to show a target value, or the series average? The method involves adding a new series, applying it to the secondary axes, and making the secondary axes disappear. Use this data to make a column or line chart
- The following excel tutorial show how you can add a vertical date line to your graph. This will enable you to see a dynamic date range in your graph that cha... This will enable you to see a.

To convert the chart into a vertical line chart, let's make the following changes Click on Select Data (appears in the right click menu You have to convert the added series to an XY chart series (right click on the series, Chart Type). Also, your line falls midway between 4/17 and 4/18, so you need to use noon on 4/17 as the X value, that is 4/17/11 12:00. Here is a set of articles about adding lines to Excel charts: http://peltiertech.com/Excel/Charts/AddLine.htm **Add** a **Vertical** **Line** **to** a Column or **Line** **Chart**: Error Bar Method. How do you **add** a nice horizontal **line** **to** a column or **line** **chart**, **to** show a target value, or the series average? The method involves adding a new one-point series with an error bar, applying it to the secondary axes, and making the secondary axes disappear ** Excel allows us to simply structure our data**.according to the content and purpose of the presentation. When we want to compare actual values versus a target value, we might need to add a line to a bar chart or draw a line on an existing Excel graph.. This step by step tutorial will assist all levels of Excel users in the following

Step 1: Click anywhere on the chart and the Design Tab will appear in the Ribbon (Chart Design tab in Excel 2019); Step 2: In the Design tab, click Add Chart Element ; Step 3: Click Gridlines from the drop-down list, then select the following Gridline types Primary Major Horizontal, Primary Major Vertical, Primary Minor Horizontal or Primary Minor Vertical * In the chart, select the data series that you want to add a line to, and then click the Chart Design tab*. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. Click Add Chart Element, and then click Gridlines This will give you a chart that has the secondary axis and the chart type of data on a secondary axis is a line chart. You can also format the line by right-clicking and selecting the Format Data Series option. Simple things such as making the line and columns in contrasting colors can make your Excel charts professional and easy to understand For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. Click Add Chart Element > Axes > and select between Secondary Horizontal or Second Vertical. Add an axis title for a secondary axis. This step applies to Word for Mac only: On the View menu, click Print Layout

- The vertical lines can only be added to a normal chart which has been created using the pivot table ; they cannot be added to a pivot chart. I may be wrong
- This single amount will be used to provide a vertical dotted line. Select the range A1:C13. Create a standard Line Chart and delete the legend. Change the Vertical Axis maximum value to match the value from column C
- To achieve this effect, add a line to your chart as explained in the previous examples, and then do the following customizations: In your graph, double-click the target line. This will select the line and open the Format Data Series pane on the right side of your Excel window
- Quickly add horizontal or vertical average or specific value line to chart in Excel. Please do with the following steps for adding the average or specific value line to a chart: 1. First, create a column or bar chart based your data, then click to select the created chart, and then, click Kutools > Chart > Chart Tools > Add Line to Chart, see.
- Adding Vertical Shaded Regions to Excel Line Chart. I want to create a line chart in Excel which features vertical shaded regions like that pictured below: Here is the chart that I am developing: I would like to add vertical shaded regions in this chart to illustrate which Prime Ministers were in charge at various periods

Add Vertical Line Between Columns in Excel Stacked Column Chart - YouTube. Watch later. Share. Copy link. Info. Shopping. Tap to unmute. grammarly.com. If playback doesn't begin shortly, try. How do I add an average line to your bar chart in Excel 2013/2016. Add Vertical Average Line to Bar Chart. Assuming that you have created a horizontal bar chart based on the original data in Range A1:B5 in current worksheet, and you want to add a vertical average line across the horizontal bar chart at a specific value. How to do it. And you.

In that case, you'll want to add a vertical line across the horizontal bars at a specific value. This quick tutorial will walk through a quick way to add a vertical line to the horizontal bar chart type in Excel. As an example, we'll use annual sales performance with an average value line. Building a Basic Horizontal Bar Chart We'll now see the bars from the Average series on the chart, but we want the Average value to be a vertical line. To do this, right-click on one of the bars and choose Change Series Chart Type . In the Change Chart Type dialog that appears, choose the X Y (Scatter) option that shows straight lines with no marks Add a vertical line to Gantt Chart Excel Stacked Bar Chart - Step by Step For any straight line you need at least two points on the chart and for each point you need two coordinates where each is representing its reference location along X and Y axis

In this post I'm going to show you a way to create an Excel bar chart with a vertical line. The inspiration was taken from this Tableau chart by Emily Tesoriero : Unfortunately, adding a vertical line to a bar chart isn't a simple feat in Excel, but I'll step you through a workaround that's relatively painless Let's say you work in super hero factory as floor manager. You are looking at the recent time sheet data submitted by your underlings and want to know who works more. So you did what any self respecting floor manager does. You made yourself a large cup of hot chocolate, whipped open Excel and created a column chart. But now, you want to add a line to it at 6:00 PM (or some other arbitrary.

- I'm trying to create a Gantt chart with Excel. I have the tasks, start dates and durations in a spreadsheet and I've built a stacked bar chart to represent the tasks and the durations. The problem comes when I try to add a vertical line that shows the current status (represented by today), like the red line on the screenshot below
- In Excel 2013 müssen Sie nur direkt eingeben 1 in Maximal Textfeld in der Achse formatieren Feld. 15. Dialog schließen. Jetzt wurde die durchschnittliche vertikale Linie zum Balkendiagramm hinzugefügt. Sie können die Zeile formatieren, indem Sie mit der rechten Maustaste auf die Zeile klicken und auswählen Datenreihen formatieren Im Kontextmenü können Sie dann die Zeile nach Bedarf in.
- Well there isn't a standard vertical line chart in Excel so we'll tweak some other type of chart to get this done! Let's get started.. Assume this Data. We have 7 periods and some values against them. Instead of a horizontal line chart we want a vertical line chart and to do that we would use a scatter chart with lines and markers . Use Scatter Chart with Lines and Markers. In the Insert.
- Add Horizontal or Vertical Average Line to a Chart: In this article, we will guide you to know the steps to Add Horizontal or Vertical Average Line to a Chart in Excel 365 using Kutools. Kutools for Excel is a third party plugin. It has more than 120 powerful built-in functions and formulas. So this Read mor
- I'm trying to add a vertical line to a chart in Sheets for visual purposes. For example, if the X axis is calendar years, a vertical line could show the point in time when a significant change happens. A similar question was asked previously, but I didn't see a reply. I would love to be able to specify for which values X there should be vertical lines displayed. Thanks! Details. Sheets.

Re: Vertical Line Charts. You could try: - Create the chart as Excel defaults to. - Select the cells behind the chart and choose (using the drop-down arrow next to the copy button on the home tab): Copy Picture. - Choose the option you want Excel Fill Under Line Chart Adding Vertical Lines. Next, we add all vertical lines to highlight the positions of the average, average - 1, 2, and 3 standard deviations and the average + 1, 2, and 3 standard deviations. The tables below show all the required elements for this distribution. Recall that we used mean 171 and standard deviation 8 to compute our y-values, so these are the figures.

- But what I would. *really* like to do is add a vertical line to the chart at the. intersection point for these 2 curves. I have 21 of these charts (7. measures, 3 biological regions) and prefer not to have to eyeball all. those intersection points, then hard-code in the values for each graph
- Time series data is easy to display as a line chart, but drawing an interesting story out of the data may be difficult without additional description or clever labeling. One option, however, is to add regions to your time series charts to indicate historical periods or visualization binary data. Here is an example where a Continue reading Adding Colored Regions to Excel Charts
- Step 4: Add the Vertical Line. Select cells D8:D12 containing the Average header and values then CTRL+C to copy. Left click the outer edge of the chart to select it > Home tab > Paste drop down > Special: It should look like this

Normally, one turns to the line tool in Excel to manually draw vertical lines on a chart. The issue is that these lines aren't bound to the x-axis, so any change to the chart is usually accompanied by manual line repositioning. Thankfully, there's a hack that can eliminate the hassle of drawing vertical lines while allowing you to instantly change their position with a few mouse clicks Select the target chart on excel. Press Alt+F11 on excel, then VBE opens. Press Ctrl+G on VBE, then immediate window opens. Paste the above code. Place the cursor on the line of the code and press the enter key. I made the file with PHPExcel and edit it with excel 2010. p.s. I confirmed with Excel 2016 without PHPExcel, too

- ology in use. The
**vertical****lines**can only be added to a normal**chart**which has been created using the pivot table ; they cannot be added to a pivot**chart**. I may be wrong. Narayan - If your line does not need to be exactly positioned, then the easiest method by far is to use a Shape to add a line to your chart. Simply click the Insert Tab on the Ribbon and select Shapes. From here, click on the straight line and click and drag the object onto your chart in the location that you desire. While this method is easy, it does.
- This is a fairly clean solution. Otherwise with VBA you would need add a shape/line to the chart (important to add it to the chartObject and not to the Worksheet). Then compute the height of points and make the line's .Left = the chart's .PlotArea.Left and make the line's .Width = to the chart's .PlotArea.Width

By default, Excel gives you a solid line. How do you get the dotted line appearance? This part is really easy! Click Once to Edit the Entire Line . If you click once on the line, you'll notice that all of the dots are selected. You can edit the entire line at once, just as you normally do. For example, you can change the line's color, width. Please follow the steps below to add the Gridlines to a Chart: Step 1: Click anywhere on the chart and the Design Tab will appear in the Ribbon (Chart Design tab in Excel 2019);Step 2: In the Design tab, click Add Chart Element;Step 3: Click Gridlines from the drop-down list, then select the following Gridline types Primary Major Horizontal, Primary Major Vertical, Primary Minor. So, if you use this way to add the target line, Excel will do all the work of keeping the whole chart up to date for you. If you'd like to know more about other interesting chart elements, to learn how you can add and format them, have a look at more tutorials by EasyClick Academy. Links to these tutorials are provided in the list below My chart has multi-level category axis labels, and I would like to have a vertical grid line separating each major group of categories. In Excel 2003, I could right-click on one of the gridlines and then specify the spacing I wanted between gridlines. In Excel 2010, as soon as I indicate that I want multi-level category axis labels, I get a vertical gridline between each category and I am.

Excel allows us to combine different chart types in one chart. This article assists all levels of Excel users on how to create a bar and line chart. Figure 1. Final result: Bar and Line Graph. Bar Chart with Line. There are two main steps in creating a bar and line graph in Excel. First, we insert two bar graphs. Next, we change the chart type. 2. Chart -> Chart Options -> Gridlines tab: both Major and Minor gridlines are checked 3. Format the Major Gridlines (e.g. at 70%), separately from the Minor ones: Select the 70% grid line and Format it. However this will only show a y-axis label at 70%, which is a problem for me, I need to show all labels Line chart. Bar chart. Column chart. Advanced charts. Custom data labels(1) Custom data labels(2) Label line chart series. Between tick marks. Add line to chart. Add pictures to chart axis. Color chart bars based on their values. Primary data hidden. Stock chart with 2 series. Adjust axis value range. Color based on prior val. Hide specific. The chart is in the middle of the Excel spreadsheet. This displays a menu next to the line in the chart. 2 Right Click in the Chart area. Click the Add Button under the Legend Entries (Series) and enter correct cells that have the data you want graphed. Click Edit under Horizontal (Category) Axis Label and click okay. Thanks! Yes No. Not Helpful 0 Helpful 10. Ask a Question. 200.

Excel chart components. Back to top. 2. How to add a vertical line to a chart. A vertical line on a bar chart would be just as useful as a horizontal line on a column chart. The picture above shows a black line on value 7.5 with transparency ca 50%. Here is how I built this chart. 2.1 Insert a bar chart. Select the data. Click on Insert on. Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis. Use Scatter with Straight Lines to show scientific XY data. To create a line chart in Excel, execute the following steps

But in line and column Excel charts, it often gets difficult to identify, which value is highest and which value is lowest. How to Insert A Dynamic Vertical Marker Line in Excel Line Chart | We can draw a vertical line on the chart manually but that just not smart. We would like to add vertical lines dynamically to mark a certain data point. Then I'll right-click, select change chart type, and select combo. Excel already suggests a line, so the only thing I need to do is tick the secondary axis box. You can see this is a much simpler way to add a secondary axis. Finally, notice the secondary axis is an ordinary value axis. The axis options area in the Format Task pane includes all.

Combo charts combine more than one Excel chart type in the same chart. One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value. In the chart shown in this example, daily sales are plotted in columns, and a line shows target sales of $500 per day. This example uses a combo chart based on a column chart to plo How To Add Horizontal Benchmark Target Base Line In An Excel Chart. How To Add A Horizontal Line Chart In Excel Target Average. Bo Chart Column With Target Line Exceljet. Add A Horizontal Line To An Excel Chart Peltier Tech. Create An Excel Line Chart With Target Range Contextures. Create Dynamic Target Line In Excel Bar Chart This post will guide you how to add secondary Axis to an existing Pivot Chart in your worksheet in Excel 2013/2016. How do I add a secondary axis to a chart in Excel. Add Secondary Axis to Pivot Chart. Assuming that you have a list of data in range A1:C5, and you want to create a pivot table based on those data, and then create a pivot chart based on this pivot table

Begin by selecting your data in Excel. If you include data labels in your selection, Excel will automatically assign them to each column and generate the chart. Go to the INSERT tab in the Ribbon and click on the Combo Chart icon to see the pie chart types, then select Create Custom Combo Chart. The Insert Chart dialog will show you a. How to add a vertical/average line to a bar chart in Power BI? Solved! Go to Solution. Message 1 of 4 5,267 Views 0 Reply. 1 ACCEPTED SOLUTION Greg_Deckler. Super User IV Mark as New; Bookmark; Subscribe; Mute; Subscribe to RSS Feed; Permalink; Print; Email to a Friend; Report Inappropriate Content 08-24-2018 08:22 AM. Go to the Analytics pane (weird sort of magnifier looking type icon with. Adding a vertical line or marker to a chart in Power BI. The user wants a marker, ideally a line to point those events on the chart. I cannot think of an out the box option, but there are some workarounds. Let's look at adding a line using Combo Chart. This chart clearly shows events as bars and tooltips can define what kind of event it was

39. Add data labels to the Series Horizontal Ref. Line and Series Vertical Ref. Line.Then, keep only one of the data labels for each series. Format the data labels to Bold and set all their Margins to zero and deselect the Wrap text in shape option. Set the Label Position to Above for the horizontal reference line and Right for the vertical reference line Steps to Add an Average Line. Below are the steps you need to follow to create chart with an horizontal line. First of all, select the data table and insert a column chart. Go To Insert Charts Column Charts 2D Clustered Column Chart. or you can also use Alt + F1 to insert a chart Band chart is also referred to as Range chart, High-Low Line chart or Corridor chart. Advantages of Band Charts. Band chart is used in the following scenarios −. Monitoring a metric within standard defined bands. Profit % for each of the regions (represented by Line chart) and bands with defined intervals in the range 0% - 100% Useful when creating excel dashboards and you want to include a threshold line/target value for your indicators. Overview: This step-by-step guide will show you how to add target values to your excel charts. Attached is an excel file to accompany the guide (you will see the various steps outlined in the excel chart) Adding_horizontal_line.xls Dynamic date vertical reference line or a dot in a line chart 01-17-2019 07:26 PM How Can I add a dynamic or constant date vertical reference line in a line chart , where x axis will be date value, y will be actual component value and after that date reference line, color of that particular line should be changed to red

- How to Add a Secondary Axis in Excel? The article below provides a step-by-step guide on how to add a secondary axis to charts in Microsoft Excel. A secondary vertical axis gives us more versatility with regards to data visualization and also provides us with the ability to plot multiple data series on the same chart. A secondary axis allows us to represent and visualize multiple data series.
- Add the (real) average values into the x field, and the (dummy) 'Average_y' values into the y field. Click OK and the average line will now be vertical across the chart. One more step though may be needed! Excel may add a bit of extra length to the secondary y axis, so your average line isn't quite matching the height of the chart
- A line graph has a horizontal and a vertical axis and uses one or more lines to show where two values intersect. Line graphs are some of the most common types of charts used to display continuous data. Since values are distributed evenly on both axes, they're great for showing trends over time and are useful for predicting future values based on historical data. Excel extends its analytical.
- Secondary axis numbers can be read from the right side vertical axis. Primary axis numbers can be read from the left side vertical axis. Recommended Articles. This has been a guide to Secondary Axis in Excel. Here we discuss how to add a secondary axis in an excel chart along with an example and downloadable excel template. You may learn more.
- imum and maximum value along the x-axis (0 and 20) as well as two y-values that are both equal to 20: Next, right click anywhere on the chart and click Select Data
- Being a variation of the line chart, the area chart places more emphasis on the gap between the data and the axis, and is commonly used to compare two or more data groups. Area Chart Basics Sections. An area chart mainly consists of 5 sections: Plot Area: This is where the graphic representation of data takes place. Chart Title: The title of the chart. Vertical Axis:The axis that.

Excel Secondary Axis Trick Step 1. Let's take this data. Now, the first thing you want to do is simply insert your chart. Insert > Charts > Select Line Chart. I hear youyou might not want a line chart, but trust me this is the easiest way to perform the secondary axis manoeuvre. You can change it to the chart type you want after you've. When you create a chart to analyze the trend of the data, it is useful to add a horizontal Average Line across the chart, so that you can compare the data clearly and easily. In this tutorial, I'll show you how to add an Average Line to Column Chart in Excel 2010 Excel Line Chart with Circle Markers. in Tutorials. I was asked recently if it is possible to make this graph in Excel. It's just a simple line chart with the data labels placed on the point instead of above or below, as is the usual case. I generally like this approach—you keep the same encoding method for the line and adding the labels in this way make for a nice design touch. It's.

- Excel Charts - Line Chart. Advertisements. Previous Page. Next Page . Line charts can show continuous data over time on an evenly scaled Axis. Therefore, they are ideal for showing trends in data at equal intervals, such as days, months, quarters or years. In a Line chart −. Category data is distributed evenly along the horizontal axis. Value data is distributed evenly along the vertical.
- When you create line charts in Excel, you're plotting data points along an X and a Y axis. This is useful for trending data over time, but what if you also want to trend how far those data points are from their ideal or how much they vary over time
- Re: adding vertical line to chart. Hi Darren, I have added a data series to the chart with some instructions above it. This is now a dynamic date line BUT if you really want VBA code post back with a little more detail on when the VBA code should be run
- Add Chart Element - Add Axis, Title, Gridlines and Trend lines For the vertical click 'Primary Vertical' which will write vertically beside the Y axis. To enter text in both these Axis title text boxes has the same set of options as for the Chart Title and can be linked to a cell content. On completion of the stages listed above the Chart should be as follows: As mentioned above the.
- Most of Excel's graphs have gridlines.The gridlines highlight data points on the charts. You can customize Excel graph gridlines from the Chart Tools tab.. First, select a few numbers on an Excel spreadsheet. Click Insert and then select a line, column or bar graph that will have gridlines.That will add a graph to the spreadsheet as below
- Click on the small vertical bar chart icon at the top left of this section. You'll now see a few different chart options. Select the first option: 2-D Column. Once clicked, you'll see the chart appear below your data. 3. Add your second data series. Now it's time to add the Percent of Nike Shoes Sold data to your secondary axis. After your.
- Summarize the data in a pivot table. Copy the pivot table data as values. Create a line chart from the copied data. Add another series to create vertical dividing lines. Add final formatting to clean up the chart. There is an overview of the steps below, and you can see the detailed instructions on my Contextures website: Excel Panel Charts

Now for the vertical axis: The reason we add two sets of actual and budget series is to cause a break in the plotted line. One set of series is always left empty for each company. This creates a break in the plotted line, i.e. the first set of data does not continue over to the next. You will find that if you copy your data into the empty columns, it ends up connecting the line for company A. As a final adjustment, add the axis titles to the chart. Select the chart. Go to the Design tab. Choose Add Chart Element. Click Axis Titles. Pick both Primary Horizontal and Primary Vertical. Change the axis titles to fit your chart, and you're all set. And that is how you harness the power of Excel quadrant charts Re: Drawing Straight Line on Chart. Thank you for your reply. I guess your suggestion would provide me with either a horizontal or vertical straight line - which is not what I'm after. I'm trying to connect two points on a graph of stock prices. This would in most cases produce a diagonal straight line

Excel; R; Python; Google Sheets; SPSS; Stata; TI-84; Tools. Calculators; Critical Value Tables; Chart Generators; Glossary; Posted on October 20, 2020 by Zach. How to Add a Vertical Line to a Plot Using ggplot2. You can quickly add vertical lines to ggplot2 plots using the geom_vline() function, which uses the following syntax: geom_vline(xintercept, linetype, color, size) where: xintercept. In July 2015 Microsoft announced that the then-upcoming Office 2016 would introduce 6 new charts to their line of charts. The one that was most highly anticipated in the financial community was definitely the built-in Excel waterfall chart.. Tip: Are you using Excel 2013 or Excel 2010?Read to the end of the article to learn how you can create one-click waterfall charts in Excel 2013 and 2010 Excel 2010 or older versions: In the Change Chart Type tab, go to the Line tab and select Line with Markers. Then right-click on the line that appears, select Format Data Series, and in the Series Options tab, choose Secondary Axis. Having done that, your combo chart should look like this: Step #5: Adjust the secondary vertical axis. How do I change line chart scale to show decimal in Excel Can anyone help - I am trying to change a line chart scale to show decimal numbers in Excel 2003. I'll cover the following topics in the code samples below: Microsoft ExcelExcel 2003, Chart, y Axis x Axis, Worksheet, and Decimal

- - then select Scatter with Straight line and markers from the drop-down - - a line will appear on the Gantt chart and another vertical axis will appear on the left. - - format the secondary vertical axis to have a minimum of 0, maximum of 1, no markers and no label Cons of Line Chart in Excel. It can be used only for trend projection, pulse data projections only. Things to Remember About Line Chart in Excel. Line Chart with a combination of Column Chart gives the best view in excel. Always enable the data labels so that the counts can be seen easily. This helps in the presentation a lot. Recommended Article

Solution #1: Display Variance Percentage on Chart. One possible solution is to add the percentage variance next to the line on the chart. Normally this would be difficult to do, but Excel 2013 has a new feature that makes this easier. In the Format Data Labels menu you will see a Value From Cells option Excel Chart With Both Bar And Line Yarta Innovations2019 Org. 3 Ways To Add An Average Line To Your Charts In Excel Part I. How Do I Center The Start Point Of A Line Between The Two. Combine Chart Types In Excel To Display Related Data. Add A Reference Line To A Horizontal Bar Chart In Excel Excel

I needed to create a dual-axis chart, with two bars on the primary axis and a line on the secondary axis. Tableau makes this task incredibly easy, but I needed to do this in Excel. Well, I really didn't HAVE to create the chart in Excel, but others needed to be able to update the chart and they, gasp, don't have a Tableau license Example: Line Chart. Example of creating an Excel line charts. The X axis of a line chart is a category axis with fixed point spacing. For a line chart with arbitrary point spacing see the Scatter chart type. Chart 1 in the following example is a default line chart: Chart 2 is a stacked line chart: Chart 3 is a percentage stacked line chart If you are using vertical bars instead of horizontal, then, you'll want to use an Excel Clustered Column chart instead of a bar chart. You can use the same steps as above, except, use a shadow angle of 270 instead of 0. This chart is shown below. Or, an option that is easier to set up but provides less control over the target marker height and width is to use a line chart with markers for.