ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   trying to combine 2 columns of data to create one x axis in graph (https://www.excelbanter.com/charts-charting-excel/110400-trying-combine-2-columns-data-create-one-x-axis-graph.html)

ChristinaA

trying to combine 2 columns of data to create one x axis in graph
 
I am trying to combine 2 columns of data to create on x axis (I have to
create an Asthma peak flow chart and have 4 different times per day with
figures - before & after), so each day has 4 lines. I need to show data and
graph (if possible) on one sheet to take to the hospital. At the moment the
column is too long to be readable in landscape (with graph) and I can't find
a way to change orientation of graph to make it readable in portrait. Is
anything possible (my dates are like 01 8, 01 12, 01 16, 01 20 etc. for
every day in the month).

Bernard Liengme

trying to combine 2 columns of data to create one x axis in graph
 
Send me the file and I will fix it for you
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ChristinaA" wrote in message
...
I am trying to combine 2 columns of data to create on x axis (I have to
create an Asthma peak flow chart and have 4 different times per day with
figures - before & after), so each day has 4 lines. I need to show data
and
graph (if possible) on one sheet to take to the hospital. At the moment
the
column is too long to be readable in landscape (with graph) and I can't
find
a way to change orientation of graph to make it readable in portrait. Is
anything possible (my dates are like 01 8, 01 12, 01 16, 01 20 etc.
for
every day in the month).




ChristinaA

trying to combine 2 columns of data to create one x axis in graph
 
Have sent you an email - hope I did it right. If not can you let me know
Thanks

"ChristinaA" wrote:

I am trying to combine 2 columns of data to create on x axis (I have to
create an Asthma peak flow chart and have 4 different times per day with
figures - before & after), so each day has 4 lines. I need to show data and
graph (if possible) on one sheet to take to the hospital. At the moment the
column is too long to be readable in landscape (with graph) and I can't find
a way to change orientation of graph to make it readable in portrait. Is
anything possible (my dates are like 01 8, 01 12, 01 16, 01 20 etc. for
every day in the month).



All times are GMT +1. The time now is 03:00 PM.

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