charts and average line

[guitarist00]

good afternoon,

im looking for adding an average line on my chart where it will move automatically when i change numbers .

here is an exmaple picture of the line i want to draw
chart photo.jpgchart.xlsx

i attached the photo i wanna make the chart looks like it

also i attached an excel chart .

can someone teach me how to do it in baby steps ?

thank you

regards,
Hani

[Glenn Kennedy]

Here you go. Just add another data series. see file.

[Glenn Kennedy]

Baby steps.

Once added, the average line appeared as a bar chart. I then changed the chart type to a line graph and turned off the data markers, so that it just looks like a line. OK?

[guitarist00]

thx that what i want


but still i didnt know how to do it

im no good in charts . and i dont know how to turn off the data marker and why do i need to change the chart


is there a video where i can see how its been made ?


regads,
hani

[Glenn Kennedy]

Yes. There will be lots of videos on Youtube. Here's one
https://www.youtube.com/watch?v=_QK0OJTYI5M

It's not exactly the same as your case - in this video they were starting with a line chart, not a bar chart, but you'll get the general idea.

[guitarist00]

thx Glen. if i dont know how to do it. then im gonna have to skype you and show me the steps lol

thx

regards,
Hani

[Glenn Kennedy]

If you need to, that can be arranged!!

[guitarist00]

thx Glen!!!

ive done it also i finally learned the F4 ($) symbol in function and why its been used for


great video

regards,
Hani

[Glenn Kennedy]

OK. If that is all, please mark the thread as solved. It would also be nice if you clicked the Add Reputation button at the foot of this post.