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
That is what I want. I would like the chart to be larger so the dates on the bottom show better and I will only be adding the data for the users as in column B each week as we reach that date so I want it to update or create a new chart each time.
So Im sorry but I dont know how to make it yet and I did try downloading but cant see anything happening.
If it is downloading I dont see it or see where it went. I dont know what the download really is. I see the spreadsheet and chart and that is what I want but I need to know how to get there
I rebooted and the download worked. My problem now he has the first date shown is January 14th and should be seventh. It does the same thing when I built the chart
I sent a response to just answer and they said they forwarded it to you. I am not sure what you hours are. but let me know if this is usuall.
No. did you get the file I sent to the techsupport people. They said they sent it to you. I dont know how to send it through here. When I put in the data it does not work. and the first comparison should be from the 1st of January to the 7th as that is when the intial data figure are inputed so I had asked if the first fields in the DATE column should be the first and the first data input should be on the 7th. THERE IS NO COMPARISON SHOWN ON THE GRAPH ON THE 7TH AND THERE SHOULD BE. If you tell me how or where to send the file with my data input I will.
Also I will be leaving the Office in a few minutes but will be able to look at this when I get home in a hour or so.
Oh, sorry -- yes, they did email it to me, but they did so without any explanation as to why they were emailing me, so I didn't even know the attachment was there. The problem is that in the first row, the underlying value of the Date is 01/07/2013, not 01/07/2012. Click that cell, change the year to 2012, and you'll see the line graph extend to January 7th.Note that it won't show a point for the 2013 visitors until you add a value for 01/14 -- that's because in a line chart, it can only graph when it has at least two points. Otherwise, it has nowhere to draw the line. If you want to see a dot appear for 01/07, right click the Chart, click Change Chart Type, and choose the fourth kind of scatterplot instead.
I rated you so why am I getting emails asking about how it was. are they just saying do you have any other qauestions?