Insert graph in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to add a line graph to a single cell as an update of progress by per cent.
 
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.
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
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.
 
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
 
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.
 
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
any
For my purposes that isn't going to work. The REPT formula does work. So thanks for your help
Evon
 
Back
Top