Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kim
 
Posts: n/a
Default Help with sales chart

Can anyone help with this please I have daily sales figuers for 3 months I
want to do a chart showing this and also the peak days of sales.

I have inputted the individual sales figures for each day and I'm trying to
get the Sales figures on the vertical axis and the months on the horizontal
axis with the line for sales figures showing the flow of visitors over the 3
month period. what is the best way to show this and what type of chart?

Sheet is like this
May June July
234 365 342
324 354 253
Ans so on May has about 8 days The others about 27

Thanks for any help

Kim
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

Do you want a point for each day on the chart, or just the aggregate by
month?

"kim" wrote in message
...
Can anyone help with this please I have daily sales figuers for 3 months I
want to do a chart showing this and also the peak days of sales.

I have inputted the individual sales figures for each day and I'm trying

to
get the Sales figures on the vertical axis and the months on the

horizontal
axis with the line for sales figures showing the flow of visitors over

the 3
month period. what is the best way to show this and what type of chart?

Sheet is like this
May June July
234 365 342
324 354 253
Ans so on May has about 8 days The others about 27

Thanks for any help

Kim



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
Chart formatting Christianovitch Charts and Charting in Excel 1 January 19th 05 10:55 PM
tracking sales to targets in a chart Brad Charts and Charting in Excel 2 December 30th 04 04:12 PM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM
Why do my text boxes disappear from my chart when I click out? Robboo Charts and Charting in Excel 1 November 27th 04 05:49 PM


All times are GMT +1. The time now is 10:06 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"