Menu
I got an excel table with two columns: date (dd/mm/yyy hh:mm) and value (integers).
The table has about 8000 values in a time range of 4 days.
When I try to create a line or bar chart on these two columns, excel somehow accumulates all values for one day (ignoring the time). i.e. I get a bar chart with 4 bars.
What I actually want is having a bar/line chart where every single row resembles a bar/point in line chart. Where can I find the friggin option to tell Excel what I want?
INFO: I use MS Excel for Mac: 2011, but I am pretty sure this is not a version related issue, but rather a 8th layer problem ;)
572
You can turn off automatic date and time grouping in Excel Pivot Tables by changing the default behaviour in the Options settings. Click on your FILE menu item and choose Options. As shown below, in the DATA section choose to 'Disable automatic grouping of Date/ Time columns in Pivot Tables.
Ungroup grouped data Right-click any item that is in the group. Select Ungroup.
The ability to quickly group dates in Pivot Tables in Excel can be quite useful. It helps you analyze data by getting different views by dates, weeks, months, quarters, and years. For example, if you have credit card data, you may want to group it in different ways (such as grouping by months or quarters or years).
When you create an axis that has time and date values, Excel tries to be helpful and guess what you are trying to do. I'm not sure about the mac, but in Excel 2010, when you right click the axis, and format it, this is the first window that pops up:
For the Axis Type (seen around the middle here) it has Automatically select based on data selected. This is what is grouping your data together as dates. Change it to a Text axis, and all the points on your graph should now appear.
63
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
