How can we display the records through chart on excel sheet

[prince]

Hello Sir, Will you please tell me the macro code to display marks through Column Chart on Feedback Report sheet of attached file.
Thanks & regards,
Prince

[HansV]

What do you mean by "display marks through Column Chart"?

[prince]

Sir when i drag the complete record ( Group of 34 Rows ) then during drag the chart marks display the record of 1st student only . it doesn't change according to the record wise.

[HansV]

See Problem Related to drag chart in Excel.

[Rudi]

You can use the same macro as in Hans's link, except:

Change this line:

Code: Select all

Set rgA = Range("B" & r - 4 & ":C" & r - 2)

To this line:

Code: Select all

Set rgA = Range("B" & r - 9 & ":D" & r - 2)

[prince]

Its working Mr. Rudi, Its working , but column lines on some records are not showing accurate level of lines.
like Maximum & Obtained marks are equal but the level of line are differ so much.
Regards,
Prince

[HansV]

For AmanPreet Kaur, the obtained marks for English is 9.5 but since you don't display the decimal, this is displayed as 10. The chart column represents 9.5 though, so it is less tall than the maximum marks column.

[prince]

Right Mr. Hans. Thank You Sir.

[HansV]

Perhaps you should display the obtained marks with 1 decimal place. That would make it clearer.

[prince]

Sir i have done it. Will you please tell me Column E Remarks column with obtained marks why its not showing proper remarks ?
Thanks & regard
Prince

[HansV]

Same problem. Your formulas don't take marks such as 9.5 into account: 9.5 is not equal to 10, 9, 8, etc., so the formula returns the remark for a very low score.
What do you want to display if the obtained mark is 9.5, or 8.5, or 7.5 etc.?

[prince]

I got your point Sir.
Thank you so much

[prince]

Mr. HansV I'm trying to change the number format in format option on sheet1 , but why is not showing effect & showing auto round off numbers.
Regards,
Prince

[HansV]

That is because of the conditional formatting that you have applied. If you remove the conditional formatting rule with formula =COUNTIF($A4:$I4,"")<9, you'll see the decimals.

[prince]

ok Mr. HansV , But i want both on same workbook. Is this possible ?
Regards,
Prince

[HansV]

Sorry, I don't understand your question. What do you mean?

[prince]

Sir, I want auto border of cells with decimal value. Is this possible?

[HansV]

See the attached version.

I have corrected the formulas and conditional formatting. There is only one conditional formatting rule now instead of many.

send file.xlsx

[prince]

Its working exactly as i want. Thank You Mr. HansV.
Regards,
Prince