| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I display 2 data series with different starting dates | Charts and Charting in Excel | |||
| How to Draw a chart line connecting 2 points in the middle of the series | Charts and Charting in Excel | |||
| Data labels in middle of the chart | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| How to get a polinom trend eq. for data series not starting at 0? | Charts and Charting in Excel | |||
Hybrid Mode
