Data Table in Excel Chart

Jose Miguel

Board Regular
Joined
Feb 3, 2005
Messages
99
This might seem like a dumn question, but is there anyway of adding a data table to a graph and NOT including the x-axis values in the data table (putting a space between the x-axis and the data table)? I somehow did it for one of my graphs but can't see how I did it! Thanks.

Jose
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,922
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Data tables are a regular pain, because they are so inflexible. I never use them, preferring to label points or create a table in the cells near the chart. The worksheet allows much more control over content and format of the table.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,727
Members
410,630
Latest member
JFORTH97
Top