Hi, I've got a bar chart that I want to add %'s to in a table below the graph. The file attached has the %'s in them, I just can't figure out how to add them to the graph.
Hi, I've got a bar chart that I want to add %'s to in a table below the graph. The file attached has the %'s in them, I just can't figure out how to add them to the graph.
Hi
I may be wrong, but I don't think its possble to exclude from the chart table something that in in the chart, or include something that is not in the chart. A couple of possible workarounds could be:
- Add the extra series to the chart and place a white filled box over the series that you don't want displayed to make them invisible. This would leave white space at the bottom of your chart
- Set the chart's background to transparent and place it in an area of the sheet with the table behind so the data table it is visible through the chart
- Copy a picture of the data table and insert it in the chart. If you do this using photo mode the picture will be dynamic and will change when your table changes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks