• 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.

Line graph

Skchitta

New Member
Hi,
I am trying to create line graphs in a single chart.
I am uploading the file which has data and graphs I am trying to make.

There are two assessments - Formative and Summative

Under formative assessment they have 4 assessments - FA1, FA2, FA3, FA4
Under summative assessment they have 2 assessments - SA1, SA2

For each assessment they have weightage from 0-10 and gardes A1, A2, B1, B2, C1, C2 in the roder.
I want the Weightage on X-axis and grate on Y-axis.

Now, I want to create one line graph for formative and one for summative assessments in the same chart with different colours.

I tried but not successful? can you help??!!
 

Attachments

  • Assessments.xlsx
    13.3 KB · Views: 4
Hi Sakuntala

Welcome to the forum..

Do you want soemthing like this..

tEST.png
 

Attachments

  • Assessments.xlsx
    15.6 KB · Views: 0
No. I want the scores on Y-Axis from 0-10 and Grades A1, A2, B1, B2, C1, C2 on X axis. For Formative I need the line in one color and summative I need the line in different color.
In the above graph you gave Fa1, FA2, FA3 etc on X axix. That should have A1, A2, B1, B2 etc..
 
Back
Top