Bar Chart With X Is Each Week

For weeks, we will have the first date of each week and for months, we will have the first date of each month. Display Date The text we show on the x-axis for each granularity. In case I want to show the sales by date as a line chart but want to continue showing the sales by week and month as a bar chart, I also extended the functionality

I can put it in a matrix so the count of boxes with 1 thing in for week 6 is next to that for week 7, so I can easily compare I would like to show this in a bar chart, but have the counts boxes with 1 thing for week 6 in one colour and count for boxes with 1 thing for week 7 in another colour and have them next to each other.

mattabrams As I am still stuck I try to be more precise about my issue hoping to get help again.. I need to analyze traffic data, currently 1.500.000 datasets increasing by 40.000week stored in a MySQL DB. Graphs are working in general and Grafana performs pretty well, even zooming between dates is of good performance, however there is one Graph I am unable to produce.

Hi All, I need to produce a line chart across three months, but show the data points by week. my data points each have a date attribute ie 5212006. I don't know a smart way to do this other than making a new table week 1, week 2, etc and lumping the data that way. Thanks as Always! Kurt

Below is an image of what I'm trying to replicate. Essentially, I want the granularity of the bars to be weekly but the x-axis to only show Monthly. As an example, I have highlighted the month of October in Power BI which is showing five different dates for each week. In excel you can show weekly bars but monthly dates on the x-axis.

If I create a simple bar chart with the x axis set to a set of two text or number fields, I get two fairly wide bars without a large gap between them. If, however, my x axis points to two fields with dates, I get two skinny bars with room for 6 other dates between them. It appears Excel is leaving room for the days in between the dates I am

Hello, I am trying to create a bar chart for project management with weeks on my axis and number of hours spent working each week as my values. The aim of this is to see if a certain person is working more than 40 hours a week or not. Here is a small extract of my full dataset. Table 1 Empl

I have a bunch of dates and was able to get the week number for each date by creating a new column using the WEEKNUM. 92 Now, I'd like to sum the total for each week and show it in a bar graph where the y-axis shows the total while the x-axis show week-over-week based on what-ever time period I specify. Thanks, Solved! Go to Solution. Labels

If you need the week numbers to be distributed evenly on the axis, you'll need to generate a new tables will all the dates use the same formula to the left of the dates and a VLOOKUP for your data -- the cells filled with NA won't appear on the chart If you need different week numbers, you can adjust the formula to taste.

I try to plot a bar plot with matplotlib to show the change of an aggregated number on a weekly basis over time my dataset has roughly 1000 weeks. Normally, when I plot such time-series, I have daily data and I convert the dates with pd.to_datetime.But in the weekly case, don't know how to specify the format in order to get an accurate x-axis labels with the years and not also with the