Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Beginner needs help to make chart or graph or pie

I only know a *little* about Excel, and a *little* about presenting data on
some kind of chart. I don't know how to do formulas or anything but a basic
spreadsheet in Excel.

My Project: I need to show that my Natural Gas usage spiked during a gas
leak involving multiple pipes leaking small amounts at the same time; the
leak wasn't noticed for 4 to 6 months. I have 3 years of gas bills-- 1 year
before the leak, the year involving the leak, and 1 year after the leaks were
noticed AND fixed. I'd like a visual rendering to make it easy for a 4th
grader (i.e. my landlord - LOL) to SEE and to understand the jump in gas
usage.

What I need to know: What "pieces" of information would I need to put on my
chart /pie / graph? I know I'd need Month-Year; billed usage...amount
used.... anything else?

Once I know what pieces of info to include, what kind of visual rendering
should I make? (chart /pie /graph ?)

So, HOW do I make this rendering? Specific instructions would be most
helpful, since this is my first attempt with doing this kind of project.

Thank you for your help.

Lifes


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default Beginner needs help to make chart or graph or pie

In column A, enter the dates
In column B enter the gas usage (cubic feet ?)
1/1/2006 2345
2/1/2006 2567
......

Click on any cell within the data
Use Chart tools to make a LINE chart

Now you should have something to work with
Go the http://peltiertech.com/Excel/ChartsHowTo/index.html to learn more

Then come back with questions but tell us what version (2007 or earlier) of
Excel you have
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Lifesnadir" wrote in message
...
I only know a *little* about Excel, and a *little* about presenting data
on
some kind of chart. I don't know how to do formulas or anything but a
basic
spreadsheet in Excel.

My Project: I need to show that my Natural Gas usage spiked during a gas
leak involving multiple pipes leaking small amounts at the same time; the
leak wasn't noticed for 4 to 6 months. I have 3 years of gas bills-- 1
year
before the leak, the year involving the leak, and 1 year after the leaks
were
noticed AND fixed. I'd like a visual rendering to make it easy for a 4th
grader (i.e. my landlord - LOL) to SEE and to understand the jump in gas
usage.

What I need to know: What "pieces" of information would I need to put on
my
chart /pie / graph? I know I'd need Month-Year; billed usage...amount
used.... anything else?

Once I know what pieces of info to include, what kind of visual rendering
should I make? (chart /pie /graph ?)

So, HOW do I make this rendering? Specific instructions would be most
helpful, since this is my first attempt with doing this kind of project.

Thank you for your help.

Lifes



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel chart showing movable graph at what point we make a profit Mim Charts and Charting in Excel 0 October 22nd 07 05:48 AM
Beginner help needed with line chart [email protected] Charts and Charting in Excel 2 April 24th 07 10:52 AM
beginner chart abdo Charts and Charting in Excel 0 April 24th 07 09:58 AM
Can I make a graph to be a specific size? (actual graph) Jessica Excel Discussion (Misc queries) 0 August 14th 06 08:45 PM
Trying to make a log-log graph Jacob Excel Discussion (Misc queries) 1 July 6th 05 12:19 AM


All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"