Join Alan Demafiles for an in-depth discussion in this video Preparing spreadsheet data, part of Cinema 4D: Animating Charts and Graphs.
- So here in this lesson we're going to start the rebuilding of this line chart that we see here in Excel inside CINEMA. So in order to import this into CINEMA there's a couple things that we need to fix here first. Number one, all this data here, it's all text. We need numerical values for that so luckily all of these values are right here so we'll just move this guy over and copy once one through 12 into here. And the last thing that we need to do is format that top part here.
And this needs to be the same column values that we'll find in our structure manager inside CINEMA 4D so these are X, Y, and Z values and before we export this out all this extra stuff shouldn't be imported over so I'm just going to select all of this, copy, and we'll make a temporary spreadsheet so we'll go here FILE, SAVE AS, and we'll name that line graph data and we'll save it as a .CSV file.
So I had this previously, I'm just going to replace it and it's going to ask you to save the active sheet, yes, and one more dialogue box saying that the formatting is going to change if you save it out in this format. Which is fine, we'll say okay on that. So we'll hop back over into CINEMA and inside this data object that I have here just an empty polygon right now we'll go back into structure and import that as keyed data that we just exported. The line graph data, and in this example, you'll see that these points are kind of bunched up and everything technically is correct because on the X, this .1 lives at this X, Y, and Z space so knowing that if we wanted to spread these guys out because these are months we can actually multiply all of this stuff by say 100.
So make this 100, 200, 300 and if you have more than 12 values and you've got a bunch, it might be easier inside Excel once we hop back in to just format this and make that happen over here. So if you wanted to multiply it by say 100 you could just, any one of these empty cells type in 100 and copy it then go back here and select all the values that you need to change come over here to EDIT, PASTE SPECIAL and it will multiply all of these values here by that number, you just got to make sure that your operation is set to multiply.
Hit Okay and now you'll notice we get all those extra numbers, so, I did it here manually inside CINEMA, but knowing that ahead of time if you've got numerous values that you're dealing with it might be easier to set up in Excel first, okay, so let's come back here and under our data object they're all points, so when we switch back to our model mode, you'll notice all those points disappear, so, we're going to use the Mograph matrix object to help visualize that. And right now it is set to Greater (mumbles) mode we'll come over here to object and by doing so it presents us with a field there we can populate so object, let's look at the data object and all those points inside that data object will now get these little cubes inside them and one thing is that we're getting one down here at the very very bottom that zero-zero world space, so, I'm going to hit H in the view port and that's going to frame everything so we can see all of our points again, in our Excel sheet we had data here but there's nothing down here at zero, so we kind of need to accommodate for that, our first point there is really the point in the structure manager it's really just a first point that we need to start off of, we need to disregard the zero point but it's not as simple as deleting this because it's going to radically change everything else over here, now everything is, this point order is changed up, you'll notice that these values shifted and that's not what we want, later on down the line it's going to complicate things, so we just need to hide this point, how do we do that? This is the data object and so when we go into points mode, if I COMMAND + A, I'm selecting all the points I want to operate on everything but that zero point so I'm going to select everything but the one at zero and coming over here to Select, Set Selection, you'll notice there's a new tag here and that tag is the point selection tag, essentially it copies all the values that you've selected in here and stores it there so that means if I deselect everything and select maybe these four points and hey I need to recall those 12 points I was working with, well it's a matter of just double-clicking this tag in the point mode and you'll have all 12 selected again.
And that's a good thing because we can use this information to feed into the matrix object, the matrix object has a field here for selection, so click and drag that tag into that selection field and now you'll notice that zero point that we had previously is hidden it's still there it's just hidden if we remove this point selection you'll see it show up again, and there it is. So essentially we've been able to take over our spreadsheet data from Excel import it into CINEMA and by using the matrix object we're able to visualize how this thing looks inside the view port we're also able to isolate the points that we do want to work on by using the set selection tag, we'll use these techniques to build off of in later videos.
This course is a project-based learning experience that will introduce different tools and techniques for importing, styling, and manipulating chart data in C4D. Alan Demafiles shows how to drive relationships between spreadsheet data and geometry with set-driven XPresso keys, connect points with tracer objects, and animate charts with dynamic primitive objects. He also explains how to customize the look and behavior of your charts and graphs to fit the style of your company or your client's.
- Using XPresso to link data
- Importing spreadsheet data into CINEMA 4D
- Harnessing mograph effectors
- Connecting dots with tracer objects
- Adding text and x- and y-axes
- Creating pie charts and bar charts with CINEMA 4D