Need to chart daily sales volumes but export from Quickbooks does not sum for each day, simply a list of all filtered transactions. The current chart is not stacking these multiple transactions.
Do I have to sum the sales for each day to chart?
What is best way to accomplish the the charting without manipulating the raw data?
See attached. I highlighted the data and selected Data-->Sub totals. I then filtered on the sub totals using the 2 on the left. I expanded your chart and it populated with only the subtotals.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Forgot to attach file
Hi,
One way is to create a PivotChart out of the data. (Basically, create a PivotTable based on the data that summarizes the amounts by date, and then create a PivotChart off that)
The sample included does that. It makes use of a dynamic named range so that you can just paste the data into the location it is and it will automatically adjust to the number of rows that are there. (Well, after you refresh the PivotTable)
Other options are available if you don't like this one.
S
------------------------------------------------------------------------------------------
If you need no more help on the current problem, please mark it as "Solved". It saves time
as many of us will look at threads if they are not marked as "Solved".
The instructions on how to do this are found in the Forum Rules thread that is at top of every forum.
(Currently you'll have to look at point #9.)
------------------------------------------------------------------------------------------
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks