Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make a fluent chart for merged cells?
Hi,
I am trying to make a chart with source data that is available in a range of merged cells (e.g. Value 1 is in the merged cells B1 to J1, Value 2 in K1 to S1 etc.). The result is a chart with many steps on the x-axis (B1, C1, D1, E1, F1, etc.) with a value on every ninth step. How do I merge the steps on the x-axis in order to have a fluent chart instead of a value every ninth step? I hope I made myself clear. Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to make a fluent chart for merged cells?
Hmmm... clearish
I suggest you get rid of the merged cells or set up some dummy cells (in between) which refer to the merged ones, and then base the chart on the dummy ie A2 A3 merged A4 A5 merged dummy B5=A2 B6=A4 chart B5:B6 hope that helps Wil " wrote: Hi, I am trying to make a chart with source data that is available in a range of merged cells (e.g. Value 1 is in the merged cells B1 to J1, Value 2 in K1 to S1 etc.). The result is a chart with many steps on the x-axis (B1, C1, D1, E1, F1, etc.) with a value on every ninth step. How do I merge the steps on the x-axis in order to have a fluent chart instead of a value every ninth step? I hope I made myself clear. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using filter to make a merged cell correspond adjacent cells | Excel Discussion (Misc queries) | |||
Make merged cells a feature that can be used in a shared workbook | Excel Worksheet Functions | |||
Merged cells in chart | Charts and Charting in Excel | |||
Chart data from merged cells. | Excel Discussion (Misc queries) | |||
Make Autofit row height work with merged cells | Excel Discussion (Misc queries) |