ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data Tables - Displaying (https://www.excelbanter.com/charts-charting-excel/125492-data-tables-displaying.html)

VBlue24

Data Tables - Displaying
 
I would like to be able to produce a simple bar chart which is illustrating
48 sets of data (half hourly useage over a 24 hour period). I want to shrink
this chart to about half a page size and display a data table alongside it
showing the 48 sets of data displayed in 2 columns (1st 24 periods and 2nd 24
periods).

Is this possible? It sounds simple enough but I cannot figure this out.
--
As always - thanks for your help

VBlue24

Bernard Liengme

Data Tables - Displaying
 
Have you considered having the chart embedded on a worksheet rather than in
a chartsheet?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"VBlue24" wrote in message
...
I would like to be able to produce a simple bar chart which is illustrating
48 sets of data (half hourly useage over a 24 hour period). I want to
shrink
this chart to about half a page size and display a data table alongside it
showing the 48 sets of data displayed in 2 columns (1st 24 periods and 2nd
24
periods).

Is this possible? It sounds simple enough but I cannot figure this out.
--
As always - thanks for your help

VBlue24




VBlue24

Data Tables - Displaying
 
Bernard, I have had created an embedded chart and this certainly helps when
cutting and pasting it into a word document and resizing. However, what I
really need to know is how to produce a data table which I can cut and paste
from another package or insert directly into Word which sits alongside the
chart.

Visually, on the page, this would then look like a chart about 2" by 3" with
a data table to the right of same size. I am using this data in a report and
trying to reproduce something which looks good visually, based on something
we cut and paste from an image, but displaying our own data
--
Thanks for your initial reply. Any further help would be greatly appreicated.

VBlue24


"Bernard Liengme" wrote:

Have you considered having the chart embedded on a worksheet rather than in
a chartsheet?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"VBlue24" wrote in message
...
I would like to be able to produce a simple bar chart which is illustrating
48 sets of data (half hourly useage over a 24 hour period). I want to
shrink
this chart to about half a page size and display a data table alongside it
showing the 48 sets of data displayed in 2 columns (1st 24 periods and 2nd
24
periods).

Is this possible? It sounds simple enough but I cannot figure this out.
--
As always - thanks for your help

VBlue24





Bernard Liengme

Data Tables - Displaying
 
Use View|Toolbars to make Daring tools available.
Make a large rectangle
Click your chart, hold down SHIFT; use Edit and select Copy Picture (only
appears when Shift is held down before hitting Edit on menu). Move to
rectangle and use Paste
Copy you picture of data into the same rectangle.
Here is the trick: after you have the chart picture and the data table the
right size and position; hold CTRL and click picture of chart, picture of
data and rectangle; now right click and use Group to make a single item of
all three
Now copy and paste to PowerPoint or Word
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"VBlue24" wrote in message
...
Bernard, I have had created an embedded chart and this certainly helps
when
cutting and pasting it into a word document and resizing. However, what I
really need to know is how to produce a data table which I can cut and
paste
from another package or insert directly into Word which sits alongside the
chart.

Visually, on the page, this would then look like a chart about 2" by 3"
with
a data table to the right of same size. I am using this data in a report
and
trying to reproduce something which looks good visually, based on
something
we cut and paste from an image, but displaying our own data
--
Thanks for your initial reply. Any further help would be greatly
appreicated.

VBlue24


"Bernard Liengme" wrote:

Have you considered having the chart embedded on a worksheet rather than
in
a chartsheet?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"VBlue24" wrote in message
...
I would like to be able to produce a simple bar chart which is
illustrating
48 sets of data (half hourly useage over a 24 hour period). I want to
shrink
this chart to about half a page size and display a data table alongside
it
showing the 48 sets of data displayed in 2 columns (1st 24 periods and
2nd
24
periods).

Is this possible? It sounds simple enough but I cannot figure this
out.
--
As always - thanks for your help

VBlue24








All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com