Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 48
Default starting a data series in the middle of a chart

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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 48
Default starting a data series in the middle of a chart

On Jun 15, 3:25*pm, pat67 wrote:
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.
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,549
Default starting a data series in the middle of a chart

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"
wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I display 2 data series with different starting dates gerry Charts and Charting in Excel 1 March 10th 09 01:39 AM
How to Draw a chart line connecting 2 points in the middle of the series KathyC Charts and Charting in Excel 3 November 28th 06 01:30 AM
Data labels in middle of the chart hile trotman Charts and Charting in Excel 2 July 28th 06 04:40 PM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
How to get a polinom trend eq. for data series not starting at 0? juannrobless Charts and Charting in Excel 3 May 9th 05 02:48 PM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"