I am not sure if this downloaded correctly to this email but I just want to have a upgradable line chart.
I am building it from Excell
The spreadsheet has the following cells
A1 is filled with DATE
B1 is filled with Unique Visitors 2012
C1 is filled with Unique Vistors 2013
A4 jan 14
A5 Jan 21
A5 Jan 28
These date continue thru A32 which reaches at dat of July 29
B3 thru B32 will be the amount of users we had (representing one week) on that day last year
C3 thru C32 will have the data of how many users (we had that week) on each of the dates in 2013.
I would like the Chart to be lined with bullets at each date
Two lines for comparison , 1 line being red the other blue
Red line with be the amount of unique visitor to my web site at each one of the dates . I will input the data each week as it comes available. for 2013
the Blue line will be the data of unique visitor we had to our web site on that date in 2012,
This should show two line going across the chart show the comparison of how many users visited the web site on each one of the dates.
from january 7th where it will start and end when we reach July 29th of this year.
The more I type the more confusing this seems but I dont think it should be.
I just want a chart to present at a staff meeting each week with the Comparisons between 2012 and 2013 on a seven day sequence. I have the data for 2012 but will have to add the data for 2013 as I get it.
Thanks and hope this helps