Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 11
Default graphing using macro

Hello,
I would like to be able to return a graph based off year end sales
information. I would like to be able to design a macro that searches all
information for year 2008, filter by company name and also by product
purchased by company; thereby ending w/ the following graphs: (1) Sales per
Yer (2) Products Purchased per Company (3) Individual sales per year.

Thanks
L.A.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200709/1

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default graphing using macro

You could start by turning on the macro recorder and producing some bits of
code. Tie them together, and when you encounter difficulties, post back with
specific questions.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"misschanda via OfficeKB.com" <u36612@uwe wrote in message
news:77d10a79aae6f@uwe...
Hello,
I would like to be able to return a graph based off year end sales
information. I would like to be able to design a macro that searches all
information for year 2008, filter by company name and also by product
purchased by company; thereby ending w/ the following graphs: (1) Sales
per
Yer (2) Products Purchased per Company (3) Individual sales per year.

Thanks
L.A.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200709/1



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 11
Default graphing using macro

Thanks will do.


Jon Peltier wrote:
You could start by turning on the macro recorder and producing some bits of
code. Tie them together, and when you encounter difficulties, post back with
specific questions.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

Hello,
I would like to be able to return a graph based off year end sales

[quoted text clipped - 6 lines]
Thanks
L.A.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200709/1

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
HELP with Graphing. scott Charts and Charting in Excel 1 October 12th 06 11:31 PM
Graphing ace Charts and Charting in Excel 1 June 23rd 06 12:32 PM
Macro for graphing jrussl Charts and Charting in Excel 1 June 15th 06 02:24 AM
graphing kckar Excel Discussion (Misc queries) 2 February 17th 06 08:51 AM
graphing kristine Excel Discussion (Misc queries) 2 December 17th 05 05:12 AM


All times are GMT +1. The time now is 11:16 AM.

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

About Us

"It's about Microsoft Excel"