I have a dataset containing a date and a number. Dates for approximately one week, but this is not guaranteed. I am trying to show the date as a label on the horizontal axis of the histogram, but it continues to show dates in interval format. I am using Visual Studio 2008. I want it to be very simple. I want a uniformly distributed histogram that has a horizontal axis label with my date and corresponding value. If the dates are 2 to 3 weeks apart, I still want the bars next to each other to have no gap.
I tried converting the date to a string using Cstr () to make it treat the date as just an arbitrary value. I tried playing with interval settings.
I was about to post a screenshot of what I was working with, but I have not yet been authorized, so I will try to describe them.
One image has the format I'm looking for.
The horizontal axis methods have dates, and for each date, there is a corresponding barrier above it with a value associated with it. Each strip is evenly distributed.
Another image was what I am getting now. Date labels are evenly distributed, but the bars are not aligned with the dates. Some of the bars are closer to each other, then others, and there are more bars than data labels.
Thank you in advance for any of your advice.
-NOTE The datasets used are different sources. The fact that the top graph of the 19th shows 100%, and the bottom 60% is explained by the fact that one of them comes from production data and another development environment.
dataset used for the bottom (report I'm working on)
start_date ------ web_percent
2012-11-19 ------ 0.6
2012-11-12 ------ +0.82222222222222222
2012-11-05 ------ 0.96
2012-10-29 ------ 0.9364
2012-10-22 ------ 0.902
2012-10-15 ------ 0.889
2012-10-08 ------ 0.86888
2012-10-01 ------ 0.85
2012-09-24 ------ 0.821
2012-09-17 ------ 0.83673469
2012-09-12 ------ +0.90384615384615
2012-09-04 ------ 0.9038461538
(I added a photo now when I did 10 rep)
