If you need urgent support, call 999 or go to your nearest A&E. To contact our Crisis Messenger (open 24/7) text THEMIX to 85258.
Read the community guidelines before posting ✨
Options
Excel: Pivot Charts Question
Former Member
Posts: 1,876,323 The Mix Honorary Guru
in General Chat
Anyone know anything about these?
I've got a Pivot table full of data, and I want to put it in a line graph. The table is the price of items purchased on particular dates. But the problem is that on certain days, we didn't buy certain items, so the field is blank. And in a line graph, when there's a blank cell, it just misses it out on the graph. So I've got an annoying graph with loads of gaps in it. How do I get the line graph to ignore the blank cell and draw the line between the two cells that do have data in instead?
I've got a Pivot table full of data, and I want to put it in a line graph. The table is the price of items purchased on particular dates. But the problem is that on certain days, we didn't buy certain items, so the field is blank. And in a line graph, when there's a blank cell, it just misses it out on the graph. So I've got an annoying graph with loads of gaps in it. How do I get the line graph to ignore the blank cell and draw the line between the two cells that do have data in instead?
0