Is this Chart Correct?

[bencar]

I got a chart problem I think I found the solution for. Here the problem. Below is my chart as a solution.

"Create a two axis (primary/secondary) graph. The primary axis should represent cars and the graph should be a line. The secondary axis should be bars and represent gallons."

[TABLE="width: 324"]
<tbody>[TR]
[TD][/TD]
[TD]2006[/TD]
[TD]2007[/TD]
[TD]2008[/TD]
[TD]2009[/TD]
[/TR]
[TR]
[TD]Cars[/TD]
[TD]581,753[/TD]
[TD]563,989[/TD]
[TD]559,051[/TD]
[TD]544,181[/TD]
[/TR]
[TR]
[TD]Gallons[/TD]
[TD]650,078[/TD]
[TD]641,784[/TD]
[TD]642,320[/TD]
[TD]620,837[/TD]
[/TR]
</tbody>[/TABLE]


Heres my graph. Let me know if this is correct. Thanks.



.


Btw, whats a primary and secondary graph? On which axis do each pertain??

.

 

[bencar]

Isn't that what you've basically got here? https://www.mrexcel.com/forum/excel...hy-pivot-table-layed-out-way.html#post5039666

Yes i do. But i got this problem after searching for exercises for many many days. In most cases I had to create my own exercises based on tuts. This became time consuming and exhausting. There seriously has to be specific resources that provide exercises. Otherwise one would be unprepared in say a job where a manager asks, "give me a vlookup for summed values for profit in the last 3 quarters." If you cant come up with that youre going to look god**** stupid explaining to him you watch tuts to get your excel training.

In school you dont watch tuts to understand calculus, finance or chemistry.

 

[Fluff]

If I gave you a workbook & told you to create a userform with 6 dependant comboboxes, using a dictionary.
How would you go about doing that, without the use of tutorials, books, examples etc?

 

[bencar]

If I gave you a workbook & told you to create a userform with 6 dependant comboboxes, using a dictionary.
How would you go about doing that, without the use of tutorials, books, examples etc?

If I asked you for the present value of a 12 year, $30,000 annuity at 5% interest would you give an answer by just watching tuts and never having to do any exercises?

 

[AhoyNC]

The questions being asked on this forum are actual issues people are trying to solve. Why not try to work them out and see if you match the answers given?