Autofill doesn't fill columns - Excel 2010

Nov 11, 2010 at 6:19 AM

It clears columns fine, but it does not fill any.

Coordinator
Nov 11, 2010 at 7:35 AM

 

Hello!

Your problem description is very brief, making troubleshooting your problem difficult.

The Autofill Columns feature allow users to map any data element in the workbook to any display element that NodeXL supports.

Using Autofill Columns, for example, you can choose to map vertex degree to vertex size.  To do so, find the row in Autofill Columns called "Vertex Size".  The drop down menu next to it will display all of the attributes found in the worksheet.  Select the "Degree" (or, if you graph is directed, the "In-degree" or "Out-degree") item, then select "Autofill".  You should now be able to find values ranging from 1 to 10 filling the Vertex Size column of the Vertices worksheet.

If this does not work for you, please consider upgrading your copy of NodeXL to the most recent version and then posting a more detailed description of the steps you are taking and the behavior you would like NodeXL to perform.

Regards,

Marc

Nov 11, 2010 at 3:03 PM

Please click the "How Autofill Columns Works" link in the Autofill Columns dialog box for information on how the feature works. If that doesn't answer your question, please provide more details here on what it is you are trying to do and what is or isn't happening in response.

-- Tony

Nov 11, 2010 at 7:35 PM

Hi Marc:

Thanks for your quick reply. The problem was that Degree and other metrics which were available as choices in the Autofill drop-downs had to be explicitly added to the worksheet – with all due respect a bit of a user trap, IMHO. Might I suggest detecting missing source columns when the Autofill button is pressed, and offering to insert those columns, so others don’t have this frustration?

-- jdm

John David Miller

Principal Engineer, Software Research & Development

Director, Visual Analytics & Cognitive Computing lab

Intel Information Technology Research

john.david.miller@intel.com

503 799-6044

From: marcsmith [mailto:notifications@codeplex.com]
Sent: Wednesday, November 10, 2010 11:36 PM
To: Miller, John David
Subject: Re: Autofill doesn't fill columns - Excel 2010 [NodeXL:234256]

From: marcsmith

Hello!

Your problem description is very brief, making troubleshooting your problem difficult.

The Autofill Columns feature allow users to map any data element in the workbook to any display element that NodeXL supports.

Using Autofill Columns, for example, you can choose to map vertex degree to vertex size. To do so, find the row in Autofill Columns called "Vertex Size". The drop down menu next to it will display all of the attributes found in the worksheet. Select the "Degree" (or, if you graph is directed, the "In-degree" or "Out-degree") item, then select "Autofill". You should now be able to find values ranging from 1 to 10 filling the Vertex Size column of the Vertices worksheet.

If this does not work for you, please consider upgrading your copy of NodeXL to the most recent version and then posting a more detailed description of the steps you are taking and the behavior you would like NodeXL to perform.

Regards,

Marc

Read the full discussion online.

To add a post to this discussion, reply to this email (NodeXL@discussions.codeplex.com)

To start a new discussion for this project, email NodeXL@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Nov 12, 2010 at 2:59 AM
Edited Nov 15, 2010 at 4:14 AM

John:

You don't need to manually add the graph metric columns to the Vertices worksheet. Instead, go to NodeXL, Analysis, Graph Metrics; check the graph metrics you want to calculate, and click OK. This will calculate the requested graph metrics and make them visible in the workbook. (You can hide them again using NodeXL, Show/Hide, Workbook Columns.) You can then use those columns in the Autofill Columns dialog box.

I can see how the presence of the graph metric column names in the Autofill Columns drop-downs can be misleading if they haven't been calculated yet.

-- Tony

 

Nov 12, 2010 at 5:19 PM

Hi Tony:

Thanks for that.

Marc and I talked by phone for quite a while yesterday about some other things, but not that trick.

Thanks for creating the tool – I’ll be playing with it a lot more, i.e., email networks. And I might hack the code, too. Is it possible to eventually do force-spring type animations, or does Excel make that difficult/impossible?

-- jdm

John David Miller

Principal Engineer, Software Research & Development

Director, Visual Analytics & Cognitive Computing lab

Intel Information Technology Research

john.david.miller@intel.com

503 799-6044

From: tcap479 [mailto:notifications@codeplex.com]
Sent: Thursday, November 11, 2010 7:00 PM
To: Miller, John David
Subject: Re: Autofill doesn't fill columns - Excel 2010 [NodeXL:234256]

From: tcap479

John:

You don't need to manually add the graph metric columns to the Vertices worksheet. Instead, go to NodeXL, Analysis, Graph Metrics; check the graph metrics you want to calculate, and click OK. This will calculate the requested graph metrics and make them visible in the workbook. (You can hide them again using NodeXL, Show/Hide, Workbook Columns.) You can then use those columns in the Autofill Columns dialog box.

I can see how the presence of the graph metric column names in the Autofill Columns drop-downs can be misleading if they haven't been calculated yet.

-- Tony


From: johndavidmiller [notifications@codeplex.com]
Sent: Thursday, November 11, 2010 11:35 AM
To: Tony Capone (Murphy & Associates)
Subject: Re: Autofill doesn't fill columns - Excel 2010 [NodeXL:234256]

From: johndavidmiller

Hi Marc:

Thanks for your quick reply. The problem was that Degree and other metrics which were available as choices in the Autofill drop-downs had to be explicitly added to the worksheet – with all due respect a bit of a user trap, IMHO. Might I suggest detecting missing source columns when the Autofill button is pressed, and offering to insert those columns, so others don’t have this frustration?

-- jdm

John David Miller

Principal Engineer, Software Research & Development

Director, Visual Analytics & Cognitive Computing lab

Intel Information Technology Research

john.david.miller@intel.com

503 799-6044

From: marcsmith [mailto:notifications@codeplex.com]
Sent: Wednesday, November 10, 2010 11:36 PM
To: Miller, John David
Subject: Re: Autofill doesn't fill columns - Excel 2010 [NodeXL:234256]

From: marcsmith

Hello!

Your problem description is very brief, making troubleshooting your problem difficult.

The Autofill Columns feature allow users to map any data element in the workbook to any display element that NodeXL supports.

Using Autofill Columns, for example, you can choose to map vertex degree to vertex size. To do so, find the row in Autofill Columns called "Vertex Size". The drop down menu next to it will display all of the attributes found in the worksheet. Select the "Degree" (or, if you graph is directed, the "In-degree" or "Out-degree") item, then select "Autofill". You should now be able to find values ranging from 1 to 10 filling the Vertex Size column of the Vertices worksheet.

If this does not work for you, please consider upgrading your copy of NodeXL to the most recent version and then posting a more detailed description of the steps you are taking and the behavior you would like NodeXL to perform.

Regards,

Marc

Read the full discussion online.

To add a post to this discussion, reply to this email (NodeXL@discussions.codeplex.com)

To start a new discussion for this project, email NodeXL@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Read the full discussion online.

To add a post to this discussion, reply to this email (NodeXL@discussions.codeplex.com)

To start a new discussion for this project, email NodeXL@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com

Read the full discussion online.

To add a post to this discussion, reply to this email (NodeXL@discussions.codeplex.com)

To start a new discussion for this project, email NodeXL@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Nov 15, 2010 at 4:17 AM

John:

We've talked about adding animation to the graph layouts, but that feature hasn't been scheduled yet.  There is nothing in Excel that would prevent this; it's just a matter of finding the time to do it.  It would certainly be a nice feature to have.

-- Tony