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??

.

 

[AhoyNC]

Looks OK to me. Excel puts the primary Y axis on the left and the secondary Y axis on the right side of the chart.

 

[bencar]

Do you mind giving me 2 exercises I can do. One thats for pivot tables and another thats chart related? I want to get good at this. I'd appreciate it. Thanks.

 

[AhoyNC]

Take a look at these links.
https://www.youtube.com/watch?v=xLmtGk7Ymy8
or go to the main page of the web site and search for pivot tables, charts etc.
https://www.youtube.com/user/ExcelIsFun

https://peltiertech.com/?s=charts

 

[bencar]

Take a look at these links.
https://www.youtube.com/watch?v=xLmtGk7Ymy8
or go to the main page of the web site and search for pivot tables, charts etc.
https://www.youtube.com/user/ExcelIsFun

https://peltiertech.com/?s=charts

I really dont think you understand what i'm requesting. I'm not looking for tutorials. I'm looking for exercises. If you know of any post me a link. Thanks.

 

[AhoyNC]

I think if you take the time to look that the link Excel is Fun has a website that list problems and the answer. You can try working out the problems yourself and then look at how he solves the problem.
https://people.highline.edu/mgirvin/excelisfun.htm

 

[bencar]

I think if you take the time to look that the link Excel is Fun has a website that list problems and the answer. You can try working out the problems yourself and then look at how he solves the problem.
https://people.highline.edu/mgirvin/excelisfun.htm

I'm somewhat confused here. I went to the link and downloaded a few workbooks. All I saw were problems many of which were blank without any answers. Are they to be used in conjunction with the ExcelIsFun youtube videos?

 

[Fluff]

Try reading what it says at the top of the sight highlighted in red.
It might give you a clue

 

[bencar]

Try reading what it says at the top of the sight highlighted in red.
It might give you a clue

Ok the problem is that most of these are "work along" workbooks and not practice exercises themselves. I havent seen any workbook with questions that go like, "do a pivot table finding the sum of all sold items from last year's sales revenue." You see? Thats a REAL practice question.

If you could find a few from the link I'd appreciate it. But so far I havent found any.

Also, I want to get very good at excel. I'm between beginner and intermediate level. What training exercises do you suggest I get started on? I just dont want tutorials by themselves. I want training with training workbooks that asks exercise questions and gives answers for correction. Basically i'm asking the same question but more in depth.

 

[Fluff]

I havent seen any workbook with questions that go like, "do a pivot table finding the sum of all sold items from last year's sales revenue."

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