3/11/2023 0 Comments Insert horizontal line publisherThis is how to add a horizontal line to a chart. Enter a description of the horizontal line and format the font. Delete all with the Delete key except one. Go to the Ribbon and add data labels.Ĭlick on your horizontal line and select Ribbon > Design > Add Chart Element > Data Labels> Center.ĭata labels will appear. The only way I can see of doing this in Publisher is by trying to draw a line which is, what can I say, clunky. So it you have a 2 column newsletter you can put this line below one section. The next step is to add a description of the horizontal line. For those of you who might know it, Mailchimp has this great facility which enables you to create a horizontal line. ![]() The final result would look something like this: On the chart type, change the chart to line. Right click on any of the average series (1), and choose change chart (2).ħ. Choose the cell for series' name (1), and cells for the values (2). Right click on any of the series, and choose select data.Ĥ. You should repeat this step on all the remaining cells to match the rows of the remaining columns. Note: This step is just a possible way to inform Excel what information to use for the line. Add a new label to the data (1), and click on the cell under it to type =average(all the data with value) (2). Chart preparationīut, first we need a chart that looks like this:ġ. Inserting a horizontal line into a chart is very possible. In this Excel charting tutorial, you will learn how to add a horizontal line to a graph. How to add horizontal line to chart? Details
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |