PC Review


Reply
Thread Tools Rate Thread

Charting Basics

 
 
Spike9458
Guest
Posts: n/a
 
      4th Jun 2004
Would like to know if anybody can post a link here to a site or two with
some basics on how to set a chart up? I'm working on a bar chart, and it's
not breaking down the way I want, and I've forgotten a bunch since my last
charting session last fall ...

Thanks in advance,

--Jim


 
Reply With Quote
 
 
 
 
Debra Dalgleish
Guest
Posts: n/a
 
      4th Jun 2004
Jon Peltier has a charting tutorial on his web site:

http://www.peltiertech.com/Excel/ChartsHowTo/index.html

Spike9458 wrote:
> Would like to know if anybody can post a link here to a site or two with
> some basics on how to set a chart up? I'm working on a bar chart, and it's
> not breaking down the way I want, and I've forgotten a bunch since my last
> charting session last fall ...



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Reply With Quote
 
Spike9458
Guest
Posts: n/a
 
      5th Jun 2004
Thanks!


 
Reply With Quote
 
Spike9458
Guest
Posts: n/a
 
      5th Jun 2004
I went thru the tutorial, now I have a question. My data is in a
spreadsheet, and there are a total of I have a list of property values,
ranging from $43000 to $750000. I am trying to put together a column chart,
where each bar represents the number of units sold in a given price range.
First column to be $0 to $49999, second to be $50000 to $99999, and so on,
up to the highest priced one ... can you help point me in the right
direction?

Thanks,

--Jim

"Debra Dalgleish" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Jon Peltier has a charting tutorial on his web site:
>
> http://www.peltiertech.com/Excel/ChartsHowTo/index.html
>
> Spike9458 wrote:
> > Would like to know if anybody can post a link here to a site or two with
> > some basics on how to set a chart up? I'm working on a bar chart, and

it's
> > not breaking down the way I want, and I've forgotten a bunch since my

last
> > charting session last fall ...

>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>



 
Reply With Quote
 
Debra Dalgleish
Guest
Posts: n/a
 
      5th Jun 2004
You should be able to adapt Jon's instructions for a conditional chart.
Use your price ranges for the min and max values:

http://www.peltiertech.com/Excel/Cha...nalChart1.html

Spike9458 wrote:
> I went thru the tutorial, now I have a question. My data is in a
> spreadsheet, and there are a total of I have a list of property values,
> ranging from $43000 to $750000. I am trying to put together a column chart,
> where each bar represents the number of units sold in a given price range.
> First column to be $0 to $49999, second to be $50000 to $99999, and so on,
> up to the highest priced one ... can you help point me in the right
> direction?
>
> Thanks,
>
> --Jim
>
> "Debra Dalgleish" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>>Jon Peltier has a charting tutorial on his web site:
>>
>> http://www.peltiertech.com/Excel/ChartsHowTo/index.html
>>
>>Spike9458 wrote:
>>
>>>Would like to know if anybody can post a link here to a site or two with
>>>some basics on how to set a chart up? I'm working on a bar chart, and

>>

> it's
>
>>>not breaking down the way I want, and I've forgotten a bunch since my

>>

> last
>
>>>charting session last fall ...

>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>

>
>
>



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Need the basics. . . Bob Windows Vista File Management 0 23rd Sep 2009 05:09 PM
Custom charting - Stacked charting with a line Randy Lefferts Microsoft Excel Charting 3 3rd Mar 2005 03:10 AM
Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer" VJ Microsoft Excel Setup 0 11th Dec 2003 09:01 AM
Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer" VJ Microsoft Excel Charting 0 11th Dec 2003 09:01 AM
Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer" VJ Microsoft Excel Programming 0 11th Dec 2003 09:01 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:46 PM.