starting a data series in the middle of a chart


P

pat67

Hi. I have a chart that shows values from January thru December. The
values from January to May are actual, but the values from June to
December are projected. what I need to do is show the actual vakue
from Jan to May which is easy. the hard part is starting the projected
value at June. When i entered the data, the value for projected shows
in the chart at January even though the table value shows it starting
in June. I cannot figure this out. Any ideas would be appreciated.
Thanks
 
Ad

Advertisements

P

pat67

Hi. I have a chart that shows values from January thru December. The
values from January to May are actual, but the values from June to
December are projected. what I need to do is show the actual vakue
from Jan to May which is easy. the hard part is starting the projected
value at June. When i entered the data, the value for projected shows
in the chart at January even though the table value shows it starting
in June. I cannot figure this out. Any ideas would be appreciated.
Thanks

Never mind. I figured it out. Thanks all.
 
Ad

Advertisements

J

Jim Cone

Just use one series and apply data labels.
You can then format the labels for the projected portion in Red (or some such) to differentiate
them.
Or, depending on the type of chart you can simply change the color of the point marker.

One tends to get more informed help by providing particulars...
Excel version
Type of chart
Manual chart or created with code
Examples of your data and how it is arranged

--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(free and commercial excel programs)





"pat67" <[email protected]>
wrote in message
news:[email protected]m...
 

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