graphing using macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

misschanda - 06 Sep 2007 15:58 GMT

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.

Reply to this Message

Jon Peltier - 07 Sep 2007 14:26 GMT

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.

Reply to this Message

misschanda - 07 Sep 2007 16:04 GMT

Thanks will do.

>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
[quoted text clipped - 12 lines]
>> Thanks
>> L.A.

Reply to this Message