| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
To have smooth curve using time scale catergory
I created chart with timsescale as catergory type
..Axes(xlCategory, xlPrimary).CategoryType = xlTimeScale thisChart.Axes(xlCategory).Select Selection.TickLabels.NumberFormat = "0" With thisChart.Axes(xlCategory) .MajorUnit = 10 End With I am getting a unsmooth curve , I tried to use the smooth property but it didn;t help much is there any way i can get smooth curve ? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
To have smooth curve using time scale catergory
This has to be done on a series-by-series basis:
ActiveChart.SeriesCollection(1).Smooth = True Note that using smoothed lines can lead to false interpretations of where the data exists: the line may curve well beyond where any data points are plotted. Also, the line is not shaped according to any best fit of the data, but on a smoothing algorithm based only on a few local points at a time. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sun" wrote in message ... I created chart with timsescale as catergory type .Axes(xlCategory, xlPrimary).CategoryType = xlTimeScale thisChart.Axes(xlCategory).Select Selection.TickLabels.NumberFormat = "0" With thisChart.Axes(xlCategory) .MajorUnit = 10 End With I am getting a unsmooth curve , I tried to use the smooth property but it didn;t help much is there any way i can get smooth curve ? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
To have smooth curve using time scale catergory
This has to be done on a series-by-series basis:
ActiveChart.SeriesCollection(1).Smooth = True Note that using smoothed lines can lead to false interpretations of where the data exists: the line may curve well beyond where any data points are plotted. Also, the line is not shaped according to any best fit of the data, but on a smoothing algorithm based only on a few local points at a time. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sun" wrote in message ... I created chart with timsescale as catergory type .Axes(xlCategory, xlPrimary).CategoryType = xlTimeScale thisChart.Axes(xlCategory).Select Selection.TickLabels.NumberFormat = "0" With thisChart.Axes(xlCategory) .MajorUnit = 10 End With I am getting a unsmooth curve , I tried to use the smooth property but it didn;t help much is there any way i can get smooth curve ? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
To have smooth curve using time scale catergory
Jon,
I tried to use this before but still it is not smooth the curve is jagged . -- Thanks "Jon Peltier" wrote: This has to be done on a series-by-series basis: ActiveChart.SeriesCollection(1).Smooth = True Note that using smoothed lines can lead to false interpretations of where the data exists: the line may curve well beyond where any data points are plotted. Also, the line is not shaped according to any best fit of the data, but on a smoothing algorithm based only on a few local points at a time. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sun" wrote in message ... I created chart with timsescale as catergory type .Axes(xlCategory, xlPrimary).CategoryType = xlTimeScale thisChart.Axes(xlCategory).Select Selection.TickLabels.NumberFormat = "0" With thisChart.Axes(xlCategory) .MajorUnit = 10 End With I am getting a unsmooth curve , I tried to use the smooth property but it didn;t help much is there any way i can get smooth curve ? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
To have smooth curve using time scale catergory
Jon,
I tried to use this before but still it is not smooth the curve is jagged . -- Thanks "Jon Peltier" wrote: This has to be done on a series-by-series basis: ActiveChart.SeriesCollection(1).Smooth = True Note that using smoothed lines can lead to false interpretations of where the data exists: the line may curve well beyond where any data points are plotted. Also, the line is not shaped according to any best fit of the data, but on a smoothing algorithm based only on a few local points at a time. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sun" wrote in message ... I created chart with timsescale as catergory type .Axes(xlCategory, xlPrimary).CategoryType = xlTimeScale thisChart.Axes(xlCategory).Select Selection.TickLabels.NumberFormat = "0" With thisChart.Axes(xlCategory) .MajorUnit = 10 End With I am getting a unsmooth curve , I tried to use the smooth property but it didn;t help much is there any way i can get smooth curve ? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
To have smooth curve using time scale catergory
You mean it's pixelated? That's a matter of screen or printer resolution.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sun" wrote in message ... Jon, I tried to use this before but still it is not smooth the curve is jagged . -- Thanks "Jon Peltier" wrote: This has to be done on a series-by-series basis: ActiveChart.SeriesCollection(1).Smooth = True Note that using smoothed lines can lead to false interpretations of where the data exists: the line may curve well beyond where any data points are plotted. Also, the line is not shaped according to any best fit of the data, but on a smoothing algorithm based only on a few local points at a time. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sun" wrote in message ... I created chart with timsescale as catergory type .Axes(xlCategory, xlPrimary).CategoryType = xlTimeScale thisChart.Axes(xlCategory).Select Selection.TickLabels.NumberFormat = "0" With thisChart.Axes(xlCategory) .MajorUnit = 10 End With I am getting a unsmooth curve , I tried to use the smooth property but it didn;t help much is there any way i can get smooth curve ? |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
To have smooth curve using time scale catergory
You mean it's pixelated? That's a matter of screen or printer resolution.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sun" wrote in message ... Jon, I tried to use this before but still it is not smooth the curve is jagged . -- Thanks "Jon Peltier" wrote: This has to be done on a series-by-series basis: ActiveChart.SeriesCollection(1).Smooth = True Note that using smoothed lines can lead to false interpretations of where the data exists: the line may curve well beyond where any data points are plotted. Also, the line is not shaped according to any best fit of the data, but on a smoothing algorithm based only on a few local points at a time. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Sun" wrote in message ... I created chart with timsescale as catergory type .Axes(xlCategory, xlPrimary).CategoryType = xlTimeScale thisChart.Axes(xlCategory).Select Selection.TickLabels.NumberFormat = "0" With thisChart.Axes(xlCategory) .MajorUnit = 10 End With I am getting a unsmooth curve , I tried to use the smooth property but it didn;t help much is there any way i can get smooth curve ? |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
To have smooth curve using time scale catergory
Jon
If you can give me any email id I can send you the screen shot sample . Here I think we do not have option to attach any files. -- Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How does Excel smooth chart data when smooth option is selected? | Charts and Charting in Excel | |||
| Fill in the blanks to smooth my projection curve | Excel Discussion (Misc queries) | |||
| How do I change the scale of logrithmic curve on the x-axis? | Charts and Charting in Excel | |||
| how do you split the scale (x-axis) on a curve graph? | Charts and Charting in Excel | |||
| Generate a smooth curve from uneven data points in a "stepped" co. | Excel Worksheet Functions | |||
Linear Mode
