• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need to set up line chart

tomas

Active Member
Hello

I need to set up graph from data. I hopefully described that well in the attachement. I might as how it was done if I don't understand because will need to replicate it

tahnks in advance
 

Attachments

  • chandoo.xlsx
    19.2 KB · Views: 0
Hi tomas,

Your data is in pretty good shape, just to setup a chart data area. See the attached. You'll probably want to further format the chart, but the basics are there.
 

Attachments

  • chandoo LM.xlsx
    29.3 KB · Views: 0
Tomas

I would simply
Select the chart, Copy (Ctrl+C)
Move to a new cell say H32
Paste (Ctrl+V)
Select the new Chart
Select the series
It will highlight the used ranges on the data
Drag the ranges to the new data
Change the Title

Repeat all the above
 
Back
Top