linear chart

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,
I've series of data (functions not original data) staedy
for 12 months this year and i would not like change it!
Actually we've July and in remain months on linear chart
fall to zero. I want only linear chart (i know in another
type of chart don't occur this effect) and i want steady
series for 12 month.
Is there any solution in chart/programming to don't show
fall on linear chart when data(function)equal zero.
I would not like also delete function in remain month.

Any help will be apprecitated

Regards
Mark
 
I asked this same thing 2 weeks ago. You cannot avoid a
blank plotting as a zero. What you can do is write a macro
to search for blanks in cells, and delete = clear contents
of cell. Then of course you need another macro to re-
instate the formulas.
 
Bob -

But "" is not a blank. Jerry's suggestion helps change the text string
"" which plots as zero to an error that doesn't plot.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Hi Jon,

Check Bob's post again. He suggests a macro that deletes the contents
of the cell, not a "" string.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
I just did reread the post. Bob wants a macro that deletes the contents
of a "blank" cell.

If the cell really is blank, it wouldn't need deleting. It needs
deleting if it looks blank, but contains "". Jerry's suggestion is an
easier way to get the same effect, in most cases, without using VBA.
Without, in fact, using VBA twice, first to clear the cell, then to
reinstate the contents of the cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You can have the chart generated by a macro like below whic
automatically plots only the data you have

Range("A1").CurrentRegion.Name = "chartdata"
Charts.Add
ActiveChart.ChartType = xlColumnClustered
With ActiveChart
.SetSourceData Source:=Sheets("chartdata").Range("chartdata"), _
PlotBy:=xlColumns
.HasTitle = True
.ChartTitle.Characters.Text = "Drug Ratings"
.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text
"Drugs"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text
"Ratings"
End Wit
 
Hi Duane -

Unfortunately, the OP's cells containing "" extend the current region.
However, the definition of the named range chartdata could be tailored
to find only numerical values, say, or cells satisfying LEN(cell)>0.

Often I build my dynamic range in the worksheet (CTRL-F3 to open the
dialog), and stick most of your macro inside a worksheet_change event
procedure, or link it to a button in the sheet next to the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top