Excel Chart Project: For C# and VB NET Students
In this project, we're going to take an Excel spreadsheet and grab the data from it using C# and Visual Basic .NET code. The spreadsheet looks like this:
We're going to make a chart out of this data. The chart will be on a Visual Studio form, and we'll do the coding in C# and Visual Basic .Net.
When the form is launched, it will look like this:
The sales staff are all in the dropdown box at the top. We'll pull these from the spreadsheet using code and then add the names to a combo box. The combo box will look like this:
Select one of the sales staff and then click the Get Chart button. The program then pulls the chart data for that employee. The chart will look like this when the button is clicked:
You can select another member of staff and click the button again. That staff member's sales chart will then look like this:
There's a lot of complicated code to do in this project. But it will bring your programming skills on a treat!
Let's start with the form design. We'll do that in the next lesson.