The x value is where on the chart I want the line to appear, the y value is a value you probably have to guess and adjust later. The bar chart is now visible next to the data. Press with left mouse button on "2D Clustered Bar".Press with mouse on "Column" chart button.Press with mouse on "Insert" on the ribbon.The picture above shows a black line on value 7.5 with transparency ca 50%. How to add a vertical line to a chartĪ vertical line on a bar chart would be just as useful as a horizontal line on a column chart. Charting in Excel is very easy and you īack to top 2. There are only two columns in the second series because of the two cells we selected as series values.Ĭharts in Microsoft Excel lets you visualize, analyze and explain data. Select cell range B10:B11 for series values.Įxcel colored the second series differently so you can distinguish them easily.Press with left mouse button on "Add" button.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |