The data headings were all listed on two rows, so the column headings were only showing half the name. We merged the cells and the headings were correct.
Our boss had a PivotChart attached to a PivotTable and was wondering why the PivotChart kept changing when he changed the PivotTable data. Naturally the chart would change, since he was getting his data from the table. We changed the data source to be the actual data instead of the table, and had no more issues. When working with charts and tables, it's important to make sure you are pulling the data from the right place.
After the chart is created, you can move it to another worksheet and format as you wish.
Worked on by Quentin, Stephen, Bay, and Robert.
Posts
8 comments:
The first line of excel sheet defines the row. This is like a property on field in a database.
I concur.
I seem to look through the issues and find all of the fields were not right. Then we checked the data and it showed that there was being 2 columns being used. This boss should use his secretary more often.
You can change the summary Data type right click on cell and click on "summarize Data by" then choose whatever you want to show from the data sheet such as sum, count, average, max, min, and product.
Awesome, Great Work!! Its always important where your data is.
Yeah, it is important to connect the data and the right data. Entering the same data over rather than connecting it can leave a lot of room for error, plus it just makes life a whole lot easier to connect it.
Post a Comment