Bar chart for product sales

[ZenMasta]

I have an excel sheet with 3 columns
order number, quantity, order date

I would like to see a bar or line chart that shows the sales trend.

The order date column contains duplicates since there are often many orders
of the same thing on the same day. The date format is MM/DD/YYYY

The date range spans 3 years so I was thinking it would be cool to see a bar
per month that represents the quantity ordered of that month. I don't really
care about the order number appearing in the chart, I simply had to use it
when I exported the query from access.
using excel 2002

 

[Rob Parker]

Hi ZenMasta,

You say at the end that this data has been exported from Access via a query.
I suggest that to do what you want, you'd be better leaving the data in
Access and creating the chart there - either in a form or a report. Base it
on a totals query, grouping by Year(OrderDate) and Month(OrderDate), and
summing Quantity.


Alternatively, export the results of the totals query to Excel if you're
more comfortable setting up a chart in Excel than in Access.

HTH,

Rob

 

[ZenMasta]

I'll try the access ng, thanks.

Hi ZenMasta,

You say at the end that this data has been exported from Access via a
query. I suggest that to do what you want, you'd be better leaving the
data in Access and creating the chart there - either in a form or a
report. Base it on a totals query, grouping by Year(OrderDate) and
Month(OrderDate), and summing Quantity.


Alternatively, export the results of the totals query to Excel if you're
more comfortable setting up a chart in Excel than in Access.

HTH,

Rob