Need MSFT Excel Help!

[Vexir]

:( Im so pathetic, I don't use Excel much, so I need help with charts..


How do I get a chart on landscape paper to extend down pages and pages cuz otherwise its all scrunched up and its a relli big chart :fight:


so annoying lol.. ask if u want a screenie :beam:

[wizard]

Yes, give me a screenshot! :upset:

[Vexir]

Jeez jeez okay, spoiled brat.... sheesh :sigh:

:P here ya go: http://graphicslash.com/forwizard.JPG

;) and btw thats for a business CLASS, its a model, so dont try and use those stocks. lol...

[λ]

Jeez jeez okay, spoiled brat.... sheesh :sigh:

:P here ya go: http://graphicslash.com/forwizard.JPG

;) and btw thats for a business CLASS, its a model, so dont try and use those stocks. lol...

A line chart would surely be a better way of representing that than a bar chart, wouldn't it? The x-axis is time.. (I should know, there was a question about charts in a paper I did yesterday) ;)

[bwh2]

a bar graph here is not appropriate but a line graph is. i would also remove the dates in between valuations and include units on your y axis.

go into view>page break preview and change your page breaks and/or resize the graph.

[SlowRoasted]

what they said, go with a line graph

[Vexir]

But somehow my teacher did it the way I did (i have to do bar btw) and he managed it...

[Vexir]

a bar graph here is not appropriate but a line graph is. i would also remove the dates in between valuations and include units on your y axis.

go into view>page break preview and change your page breaks and/or resize the graph.


And I can't find page break preview dude, its not in my view menu, even though the excel help file says it is.. lol

[Vexir]

SOMEONE HELP O GOD IM DESPERATE!! [/noob]

Lol seriously guys, I need this to be a bar graph, everything else is fine! Heres another pic of how my data is, and wat to change:


http://graphicslash.com/Untitled-1.jpg

[Vexir]

Also, no matter how big I make the chart, the bars wont get thicker, but the # of dates will increase (along the X axis..)

[kirupa]

I wish I could help, but I don't know ANYTHING about Excel. I've never really had a need to use it :(

[Vexir]

I'm gonna fail :(

This is such a huuuge project too

[bwh2]

even when you click the down arrow at the bottom of the view menu you can't see page break preview?

//and don't worry, you're not going to fail. i can do excel in my sleep.

[bwh2]

let me see if i'm interpreting this right... you have a portfolio and it's comprised of of different stocks each week. you want the weekly bar to be the entire value of the portfolio, with the bar divided into different colors based on the proportions of value for each stock?

[Vexir]

even when you click the down arrow at the bottom of the view menu you can't see page break preview?

No.


//and don't worry, you're not going to fail. i can do excel in my sleep.

I love you.


let me see if i'm interpreting this right... you have a portfolio and it's comprised of of different stocks each week. you want the weekly bar to be the entire value of the portfolio, with the bar divided into different colors based on the proportions of value for each stock?

Well the way my teacher has it setup... eh.. you should see for yourself.. he gave me an example graph... on a word doc. Here:

http://www.graphicslash.com/PoB.doc

:) Look at the individual thing, scroll down one or two pages

[Vexir]

Okay I even tried it in MSFT word, same problem hit me: I can't turn the dam thing sideways nad expand ti across pages.

if i cud just do that, it wud be okay, i cud stretch it horizontally and it wud go across pages

unfortunately it wont let me rotate the chart, the rotate buttons on the drawing toolbar are greyed out

[Vexir]

Omfg nevermind I figured it out, in the Axes options, just change it to Category.. haha

[bwh2]

cool. let me know if you need any other help.

[Vexir]

Thanks bro :) and to everyone else who replied... except wizard. He wasted 5 minutes of my life with that screenshot. :P