Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 29th 04, 04:41 PM
DavidM
 
Posts: n/a
Default Charting Data from Excel

Hello, all! I'm new to this group and trying to figure out a way to query
data from SQL Server 2000 into Excel to graph.

Basically, I have one row of data that is collected on a weekly basis that
reports the size of a various file that we send to customers. I would like
to have Excel read the database from whatever date range that I specify, and
have it graph the size of the file for both weekly, monthly, and yearly
sizes.

Can Excel query database directly?

Does anyone have any sample charts or tutorials online that I can see how to
do this?

I suppose I could export my SQL data to a .CSV file and load that into
Excel, but I'd rather not have to perform this step, if possible.

Any help would be appreciated.

Thanks!



  #2   Report Post  
Old December 29th 04, 07:04 PM
Nick Hodge
 
Posts: n/a
Default

David

Excel can get data directly from SQL using ODBC (and several others). I
have an example of obtaining data by ODBC here.

http://www.nickhodge.co.uk/gui/datam...taexamples.htm


It uses Access but will work for SQL as you'll see in the examples.

You might also want to do the same with a pivot table chart or report using
the same sort of route, but via the menu option DataPivot table chart and
report, selecting external data source again. (Unfortunately not quite got
to Data menu on my web site yet! On ToolsOptions...), so you might want to
check out.

http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"DavidM" wrote in message
...
Hello, all! I'm new to this group and trying to figure out a way to query
data from SQL Server 2000 into Excel to graph.

Basically, I have one row of data that is collected on a weekly basis that
reports the size of a various file that we send to customers. I would
like to have Excel read the database from whatever date range that I
specify, and have it graph the size of the file for both weekly, monthly,
and yearly sizes.

Can Excel query database directly?

Does anyone have any sample charts or tutorials online that I can see how
to do this?

I suppose I could export my SQL data to a .CSV file and load that into
Excel, but I'd rather not have to perform this step, if possible.

Any help would be appreciated.

Thanks!



  #3   Report Post  
Old December 29th 04, 09:09 PM
DavidM
 
Posts: n/a
Default

This is cool. I have some reading to do. Thanks for the help!

Do you know of any books that go over charting and accessing external data
for Excel?

My next big thing is that I'm capturing all my SQL Server database sizes
every week.

I would like to have a query setup to retrieve each week's database size and
group it by week.

I'd also like to display data in Excel and then have the chart/graph appear
in same workbook to the side or bottom of the data......

Ideas?





"Nick Hodge" wrote in message
...
David

Excel can get data directly from SQL using ODBC (and several others). I
have an example of obtaining data by ODBC here.

http://www.nickhodge.co.uk/gui/datam...taexamples.htm


It uses Access but will work for SQL as you'll see in the examples.

You might also want to do the same with a pivot table chart or report
using the same sort of route, but via the menu option DataPivot table
chart and report, selecting external data source again. (Unfortunately not
quite got to Data menu on my web site yet! On ToolsOptions...), so you
might want to check out.

http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"DavidM" wrote in message
...
Hello, all! I'm new to this group and trying to figure out a way to
query data from SQL Server 2000 into Excel to graph.

Basically, I have one row of data that is collected on a weekly basis
that reports the size of a various file that we send to customers. I
would like to have Excel read the database from whatever date range that
I specify, and have it graph the size of the file for both weekly,
monthly, and yearly sizes.

Can Excel query database directly?

Does anyone have any sample charts or tutorials online that I can see how
to do this?

I suppose I could export my SQL data to a .CSV file and load that into
Excel, but I'd rather not have to perform this step, if possible.

Any help would be appreciated.

Thanks!





  #4   Report Post  
Old December 30th 04, 08:15 AM
[email protected]
 
Posts: n/a
Default

stop using Excel before it is too late

if you want to make pretty reports based on SQL Server 2000 data; the
last thing you should do is bring Excel into the mix.
Use Access Data Projects!!!

  #5   Report Post  
Old December 30th 04, 02:31 PM
DavidM
 
Posts: n/a
Default

I would I do this with Access? Can access create the same sort of graphs?



wrote in message
ups.com...
stop using Excel before it is too late

if you want to make pretty reports based on SQL Server 2000 data; the
last thing you should do is bring Excel into the mix.
Use Access Data Projects!!!





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
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM
How do I display a data table in an Excel 2002 chart? Dr. Mark F. Charts and Charting in Excel 3 December 29th 04 03:04 PM
multiple or changing colours in a data table on an excel chart fo. Kerri Buxton Charts and Charting in Excel 2 December 23rd 04 07:39 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM


All times are GMT +1. The time now is 08:37 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017