Delete Rows from Data Table

  • Thread starter Thread starter Charting Help
  • Start date Start date
C

Charting Help

I used the dummy columns method to create a 2 axes column
chart and it worked great! However, I want to be able to
show the data table with the chart, but I don't want the 2
dummy columns to show up on the table. I try right-
clicking on the chart to delete those 2 rows that I don't
want from the table, but it doesn't allow me to clear it.
Any ideas?
 
Data tables are hard to work with. You have limited formatting options,
and you can't have data in the chart that doesn't show up in the data table.

You could make your own data table in the worksheet range under the
chart, if it's an embedded chart. You can put anything in this table,
and format it exactly how you like.

If it's a chart sheet, make a table in a worksheet somewhere, copy it,
then paste it in the chart as a picture (hold down Shift while selecting
Paste Picture from the Edit menu).

- Jon
 
Back
Top