B
blubblub
Recently I started using Excel 2007. It took some time to get used to and
trying to find where they put the old menu items, but that is normal.
I am creating a spreadsheet to show linear programming problems in a
graphical way (so only using two variables) and wanted to setup one general
one, so I could copy this to new tabs/sheets.
During this exercise I ran into three problems:
1) Removing data markers
Everywhere I read about the types of scattergraphs and all have markers with
them. What happened to the old option 'no data markers'? Now I have to single
select each line then open the options and set markers to none. For a few
lines this is okay but I have 20 lines so it takes a very long time.
2) Empty cells keep on showing
This is already posted here, but still. It is annoying that the empty cells
do appear in the diagram. Now I have to change the option "" to NA()
resulting in an ugly error, which then cannot be hidden since then the lines
will never show even if there would be non na errors. Also the legend keeps
on showing the line as an option even though the actual line is not shown.
This whole problem did not occur in 2003 so why did they change this???
3) Data reference always to original sheet
This is the biggest problem and I hope someone has an easy solution. Once I
have a diagram, and use copy sheet to a new sheet, the diagram on the new
sheet is still based on the data from the original sheet. So for example the
diagram and the data are on Sheet1 then I make a copy of Sheet1, but on the
new sheet the diagram refers to the data on Sheet1 and not the data on the
new sheet.
I tried removing the 'Sheet1!' in front of the cell referencing in the
select data option, but it would not allow me to do this.
Does anyone know of a solution for this?
Well hope it is all clear and hoping that someone has a solution.
Already many thanks for any suggestion.
trying to find where they put the old menu items, but that is normal.
I am creating a spreadsheet to show linear programming problems in a
graphical way (so only using two variables) and wanted to setup one general
one, so I could copy this to new tabs/sheets.
During this exercise I ran into three problems:
1) Removing data markers
Everywhere I read about the types of scattergraphs and all have markers with
them. What happened to the old option 'no data markers'? Now I have to single
select each line then open the options and set markers to none. For a few
lines this is okay but I have 20 lines so it takes a very long time.
2) Empty cells keep on showing
This is already posted here, but still. It is annoying that the empty cells
do appear in the diagram. Now I have to change the option "" to NA()
resulting in an ugly error, which then cannot be hidden since then the lines
will never show even if there would be non na errors. Also the legend keeps
on showing the line as an option even though the actual line is not shown.
This whole problem did not occur in 2003 so why did they change this???
3) Data reference always to original sheet
This is the biggest problem and I hope someone has an easy solution. Once I
have a diagram, and use copy sheet to a new sheet, the diagram on the new
sheet is still based on the data from the original sheet. So for example the
diagram and the data are on Sheet1 then I make a copy of Sheet1, but on the
new sheet the diagram refers to the data on Sheet1 and not the data on the
new sheet.
I tried removing the 'Sheet1!' in front of the cell referencing in the
select data option, but it would not allow me to do this.
Does anyone know of a solution for this?
Well hope it is all clear and hoping that someone has a solution.
Already many thanks for any suggestion.