ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Graphing problem. Please help. (https://www.excelbanter.com/excel-discussion-misc-queries/111326-graphing-problem-please-help.html)

mizterbusy

Graphing problem. Please help.
 
Hi there,

I have a graph with columns and lines on 2 axes. I'm using the format
"Line-Column on 2 axes" but i want specific data sets presented on
lines and others on columns.

Can anyone tell me how you select whether a data source appears as a
line or column?

Any help much appreciated.

Thanks.

Kim


Dallman Ross

Graphing problem. Please help.
 
In . com,
mizterbusy spake thusly:

I have a graph with columns and lines on 2 axes. I'm using the
format "Line-Column on 2 axes" but i want specific data sets
presented on lines and others on columns.


I'm confused about where you see the format description "on 2
axes." I use plenty of two-axes charts, but I've never seen that
description in the selection-type area.

In any case, I think what you're asking is how to change some
of the data to be a different chart type. Simply click in the
chart on that data set. When it's highlighted, right-click
and choose a different chart type. The type will apply to
that data set only.

Dallman


All times are GMT +1. The time now is 06:18 AM.

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