Ms. Compy Fix-It: Excel Graphs With Strangely Spaced Charts

Hi there!  Ms. Compy Fix-It here, with another remedied Excel “issue.”

My use of quotes is intentional.  In truth, Excel is not at fault (for once), but it can certainly throw a person for a loop!

Have you ever decided to run a pivot chart, but no matter what you do, you can’t get the bars to space themselves evenly?

This happened to me today when I was testing out a dashboard I was making for a manager to use.  It was making me increasingly annoyed until I finally sought the answer from Google.  But it was no use!  My searches were returning results from Excel tips to the suggestion that I’d somehow grouped two worksheets together….. no luck.  I had to figure this one out myself.

Thankfully, the hair-pulling episode was quicker than anticipated, and involved trying to create a new Chart Type.  As soon as I selected Stacked Column instead of the standard Clustered Column, the spacing issue was fixed.  So, that made me ask myself what was different about that type of chart – and I realized the ‘extra spacing’ between the bars in my chart were actually placeholders – for data that just didn’t exist in my testing entries.  Picture this: I had Resources, and Task Statuses.  Excel’s Clustered Column chart type defined specific placeholder for each of the Task Statuses, so while I may have entered a test entry that Anthony’s task was In Progress, and Amber’s task was Completed, I hadn’t entered that Anthony also had a task that was Completed.  So the placeholder for Completed for Anthony was empty, mimicking a spacing issue (see below).

Excel Charts Spacing2
Well, that looks awkward, now doesn’t it?

But once the data fills in, each ‘space’ allotted for a Task Status will fill up, and only when they each have a data point will it look evenly spaced (see below).

Voila!
Voila!

I realized the clustered column wasn’t what I wanted to use anyway (not for a workload assessment!) but I thought I’d better post my findings here in case there’s someone out there getting as frustrated as I was, simply because there is not enough sample data to show the cause as clearly.

*****

Actually, three Excel issues plagued me today.  This one I was able to resolve, but the other two I will ask for your help as part of the greater Excel community out there:

  1. At one point when I was working with my pivot chart, I was no longer able to select the chart itself.  As in, when I clicked inside the empty space within the chart, instead of selecting the chart (enabling me to move it) it selected the cells behind the chart.  I was able to select individual parts of the chart – axis, title, etc. – but not the chart itself….. it simply could not be moved!  This was such a pain, and I hadn’t invested too much time into the file, I just copied and pasted into another new spreadsheet and re-ran the pivot chart and it was fine.  But it was very disturbing – I couldn’t drag and drop the chart to move it out of the way, and I couldn’t even right-click to see options for it!
  2. After I had copied and pasted my data from the first sheet to the new sheet, a table that was pasted included a border that I wanted to remove – but couldn’t.  I would select the data, click No Border, and it would only remove the bottom border, leaving the sides and top in tact.  When viewing the Format Cells menu of the selection, then Border, it only recognized that the bottom border was there – it didn’t recognize the sides and top!  I tried selecting individual cells and removing the border, also to no avail.  I eventually just highlighted the selection, went under the Editing tab, and Clear Formats removed it (and the rest of the formatting which I just had to re-do).  Still perplexing me what this was all about!

So, my dearest reader!  If you happen to know or have a suspicion about what caused either of the two situations above please write me in the comments section.  Or if you have had any similar experience, please let me know – you never know what additional details may lead to solving an Excel mystery!

Respectfully submitted,
Ms. Compy Fix-It  🙂

Advertisements

Ms. Compy Fix-It Fixes Microsoft Outlook’s Meeting-Hoarding Problem

Howdy world!

Ms. Compy Fix-It here, and I’m in a great mood.  I managed to resolve an issue I encountered yesterday which has been bugging me since.  That’s a long time for me to be perplexed.  🙂

Without further ado, my issue was this:

  • I go to send a meeting invite in Microsoft Outlook 2007, and it gets stuck in my Outbox
  • I could send e-mail just fine
  • Timestamps showed under the Sent column in the Outbox for regular e-mail, but the meeting invites just showed “None“, indicating I could wait all I wanted but it had no intention of sending……
  • Neither time, nor restarting, nor re-opening and re-sending, could make these meeting invites get out of my Outbox
  • I went to cancel the meeting invite, and the cancellation got sent to the invitees! (How random….. and awkward)
  • Even deleting the meeting would send the cancellation notice to the invitees
  • This occurred several times as I tried different things…… causing frustration and embarrassment as I’m sure it looked like I was insane (“Insanity: doing the same thing over and over again and expecting different results.” – good ol’ Einstein)

I researched.  And researched.  And pondered.  And researched again.

And then I found a clue.  On a few sites, they’d mentioned a Norton Antivirus add-in was the cause of their troubles, but I don’t have Norton so I knew that couldn’t be it.  But one site mentioned:

Tip 1116: Meeting invitations are stuck in the Outbox | Outlook Tips
More Information
If you are having a problem with your mail not sending but aren’t using Norton Antispam, check your add-ins. Other antivirus and antispan add-ins, as well as iCloud, have been known to cause problems sending Outlook items.

Hmmmm…….. well I first had to search how to get to my add-ins – they’re not something I play around with too much.  From Outlook’s own Help file (Wait, what?  You mean it was actually helpful?  It’s a miracle!):

Enable or disable add-ins in Office programs
Outlook
On the Tools menu, click Trust Center, and then click Add-ins.

Great, easy enough.  So I get a list of my add-ins and realize – I recently downloaded Evernote for Windows!  I’m not sure why it took me so long to remember that, but I suspect frustration blindness had taken over.  😉  Anywho, I disabled the two Evernote add-ins, and voilà!  It works again.  So be aware that if you’re suddenly running into an issue of Outlook sending e-mails but not your meeting invites, check your add-ins!

Sincerely,
Ms. Compy Fix-It  🙂

Milestone (April 2007)

it helps a lot
to know he’s there
not just waiting
but feeling with me
he’s scented
fresh
exhilarated
but sadly
he is not free
I’ve waited, myself
for fear or flee
I’ve taken him
inside of me
but nothing’s left
but shards of glass
marking the point
I’ve yet to pass
and this waiting’s
got the best of me

    

     

Copyright L.M. 2007.  (written for a best friend).

Conscious (April 2007)

I haven’t seen this before
shared among common fields
I could almost feel myself move
asleep on the ground, twice already
patience awoke me with presence
well I should say friends
and open faces showed me something
I can’t be alone too long
I miss the smile the most
having said what was right
I turn away not to see the consequence
since it’s not horrendous
I feel faint
and must lie down again

     

      

Copyright L.M. 2007.

The Miracle of Maybe (April 2007)

my knife has sat here all along
I watched it as it performed
magic
simply
and I could have waited
but the fans related
as I was thrown in
a sea of strangers
sadly oblivious
but I caught on and on
and I really did see a peace
they laugh, you laugh
so training began right away
worked on until sleek
smooth as ice
and forgiven I sat silent
still waiting
reminded of killers
and sounds of childhood
until finally
I was wrong
I might have mattered

       

       

Copyright L.M. 2007.

My Tiny Bag of Sand (February 2007)

under every pyramid
and bodies freshly tanned
finds the topic of my poem
it’s my tiny bag of sand

I can see it in my mind
like ideas newly planned
a little piece of Heaven
is my tiny bag of sand

people walk along the coastline
picking shells up in their hand
but they’ll never grasp the concept
of my tiny bag of sand

it’s my beauty, it’s my pleasure
it’s my way around the bland
it reminds me of a better day
my tiny bag of sand

   

      

Copyright L.M. 2007. (alternate end stanza:
it’s my beauty, it’s my pleasure
it’s my way around the bland
it reminds me of a better day
on vacation, far away
idolizing Hemingway
my tiny bag of sand )

Le Départ/The Departure (April 2007)

Le Départ

il ne prend pas beaucoup
assis sur le bord d’un rien
la valeur me dit
“ne t’inquiètes pas
il en reste assez”
mais je sais déjà
je sais

je n’étais ni le tout
ni la seule
alors je suis

avant le départ du jour
je vois du monde
assis sur mon bord
mais il n’en reste plus
et j’entends
un soupir éternel qui me dit
c’est encore assez
oui, ça je sais

The Departure

it doesn’t take much
sitting on the edge of a nothing
worth tells me
“don’t worry
there is still enough”
but I know already
I know

I was neither the all
nor the only
and so I am

before the passing of the day
I see people
sitting on my ledge
but nothing remains
and I hear
an eternal sigh that tells me
it is still enough
yes, that I know

Copyright L.M. 2oo7.