Insert graph in cell

[Guest]

I am attempting to add a line graph to a single cell as an update of progress by per cent.

 

[Andy Pope]

Hi Evon,

If I understand your post you want to use a tiny chart as a progress
indicator, based on the content of a cell.

This is possible although a bar chart may be better as this can run from
a single value. A line chart would have to be an xy-scatter and this
will require 4 values. [start and finish (x,y) values]

Instructions for bar chart,
select the cell containing the percent value. Create a clustered bar
chart using the chart wizard. You will have to format the x-axis to have
a min=0 and a max=100, otherwise the chart will continually update the axis.

Remove all axis markers,lines and tickmarks.
decrease the gap width of the bar to 0 so it fills the plotarea.

If your actual problem is how to do any of the things described above
please post back with more detail.

An alternative non chart option maybe to fill a cell with text.
I did this as a quick test and it doesn't look to bad.
Use this formula in a cell that is wide enough to display all 100
characters. A3 contains the integer percentage progress.
=REPT("×€",A3)

I am attempting to add a line graph to a single cell as an update of progress by per cent.

--

Cheers
Andy

http://www.andypope.info

 

[Debra Dalgleish]

Another option is to shade the cell, based on the percent:

If the percentage is the result of a formula, you could use the REPT
function to fill the cell. For example, with A2: 100 and B2: 35 --

1. To set the maximum width, in cell C1, enter the following formula:
=REPT("|",50)
2. Adjust the column width to fit the resulting bar
3. In cell C2, enter the following formula:
=REPT("|",B2/A2*50)
The bar will fill approx. 35% of the cell.

 

[Guest]

Debra,
Thanks. That worked well. Is there a way to add a lael of 1 and then 100?
Evon

 

[Guest]

Andy,
Thanks. This creates the bar chart I want, but does not locate it in the cell. The options are as a New Sheet or in the current sheet as a floating object. I want it to be in a single cell updating the percentage in that row only.
Evon

 

[Debra Dalgleish]

You could add the 1 at the beginning of the formula:

="1 "&REPT("|",B2/A2*50)

Enter the 100 in the next cell to the right.

 

[Guest]

Thanks.

 

[Andy Pope]

Hi Evon,

A chart is part of the graphics layer that is above the worksheet.
You can not have a chart inside a cell, only above.
You would need to create the chart as an object on the sheet and then
resize it.

Andy,
Thanks. This creates the bar chart I want, but does not locate it in the cell. The options are as a New Sheet or in the current sheet as a floating object. I want it to be in a single cell updating the percentage in that row only.
Evon

--

Cheers
Andy

http://www.andypope.info

 

[Guest]

any
For my purposes that isn't going to work. The REPT formula does work. So thanks for your help
Evon