Vb.net/datavisualization... Help displaying access data

Question

0.00/5 (No votes)

See more:

I have an access table with 100 students with Name1, Wins, Losses fields. I would like to display their wins and losses in a chart or at least something that looks better than a datagridview. I tried and with test data 35 students look awful in all charts I tried. Does anyone have any suggestions on how I can do some sort of really nice datavisualization that will show all my students and leave room for more as I grow?

What I have tried:

I tried doing it in a chart but the amount of data was too much for the chart control to look good and represent what my objective.

Posted 14-Mar-20 13:40pm

Member 11866893

Updated 14-Mar-20 22:31pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2020-03-14T20:57:00

Solution 1

We really can't help you here: we have no idea what your data looks like, or what would "Look nice" to you using it - or even what you want the display to emphasise or reveal (which is what charting is all about: giving a graphical representation of data that "brings out" important information such as trends, projections, shares, and so forth).

However, there are a huge number of different chart types, from scatter to pie - all of which help to highlight different aspects of the data.
This may help: 44 Types of Graphs and How to Choose the Best One for Your Data | Visual Learning Center by Visme[^], or a play with the data in Excel / LibreOffice Calc and their Chart facilities.

Posted 14-Mar-20 20:57pm

OriginalGriff

Comments

Member 11866893 15-Mar-20 17:20pm

I have 50 students and want to display their wins and losses. So 50 X axis entries and 50 y axis data entries on a bar chart looks horrible and it was the same on all of them I tried. That many students makes the chart difficult to read or unreadable on some. Also, my students are likely to grow to 100 or more in the next year or two so whatever I do has to be able to display 100 students. I may split the students up into smaller categories and do charts for each category. That is at least the next thing I am going to try. I really like the charts in excel they look so much better so the alternate plan is to try to export the table from access into excel and build the graph then display the spreadsheet on my form. Although, excel has the same issue I run into with the chart control except it isn't quite as bad.