Charts Excel 2003

G

Gringarlow

I have several Dynamic Charts that plot daily data and a Month to date value.
I show the data table. I am using line charts, and adding a Trendline. How
can I show the Month To Date value without having it affect the daily
trendline?
 
G

Gringarlow

I made the MTD value its own series, it posts on the chart at the far left, I
would like it to show on the right, as the daily data runs left to right.
Also, doing it this way the MTD shows in the data table as a new series,
which it should, but I would like it to show as the next value in the data
table..............I tried to copy the chart here, but it won't take it.
Am I asking for the impossible?
 
J

Jon Peltier

1. You need N-1 blank cells at the beginning of the MTD series, to offset
the MTD value to the Nth slot on the axis.

2. I hate data tables in charts. I can't format them the way I want, I can't
include and exclude data in the table, I can only show all the data in the
chart, and nothing but the data. Don't let the limited functionality of a
data table limit your chart. You have this huge grid, set aside a piece of
it for the data you want to show, format it the way you like it, and who
cares if it isn't stitched right to the category axis?

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top