Graphs
When you use the chart wizard, you specify a range. You can specify multiple
ranges, or add columns to a range, by going back to that step in the wizard
and selecting what you want.
To select non-adjacent columns of data (multiple ranges) put a semicolon
between the two ranges in the dialog box.
Dave
"Antchi" wrote:
Hello,
I am trying to set up a graph that will display values for various
dates and in the graph source range dates are displayed in columns. At
the same time, the graph's series have to be in columns. I am trying to
add a new column to the table (for a new date) but Excel does not
incorporate the additional column of data into the chart. Does anyone
have a solution?
Thanks in advance!
|