Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, 3rd day using QV..
Wanted to practice drill down, so created Excel sheet with Quarters, Months, and Weeks (1-4, Jan-Feb, 1-52) and some income and expense figures:
In my Excel sheet, July looks like this:
3 | July | 26 | 0 | 0 | 0 |
3 | Juy | 27 | 1200 | 300 | 500 |
3 | July | 28 | 0 | 0 | 0 |
3 | July | 29 | 1200 | 300 | 500 |
3 | July | 30 | 0 | 0 | 0 |
However, when I loaded the table and tried to create chart, two "July" entries show up. One bar is week 26 AND weeks 28,29,30. The other bar is only week 27. If I go to the tables in the QV sheet, and click on July in the Month table, it highlights 26, 28, 29, 30 in the week table, but not 27. On the other hand, when I click on week 27 in the Weeks table, it highlights July in the Month table. I've reloaded several times, re-entered and saved the data in Excel, but the same thing keeps happening. Any ideas?
How many times did I stare at this before seeing that "July" was spelled "Juy" in wk 27? Duhhhhh...