In that case the series would always be showing the same cell range, and its formatting wouldn't change. based on the value in some 'controller' cell), and have the series point to that row. I know that, in this case, I could add a row which has a formula to pick out the correct values (e.g. Is there a way I can stop this from happening? I just want to change the values that are shown, not the way in which they are shown. Notice how the bars changed their fill to orange! Notice how the labels got removed! Where's that green stroke and awesome 3D bevel effect? All my hard work! For nothing! I do this by clicking on the corresponding bars, and dragging the blue and red rectangles onto their correct new ranges. Now, I want to update the chart so that its second series points to the updated numbers. Notice the awesome formatting of the second series. The bar colors, the label fonts, the grid lines, etc, etc. I have an Excel bar chart that is formatted exactly the way I like it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |