I made a column chart (don't know what type of chart you want, but this technique is widely applicable) using the yellow shaded range in the first data range (top left chart). You can use a lookup formula for this, for example, the formula in D2 is: I inserted a column "Value" (blue text) in your data range that has the Y value corresponding to the label in your "Data" column. I started with your data, and I added a small lookup table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |